How to look up a column value of same table and insert another column value in new column using Mapping data flows

Question

Hi Team,

I am Inserting data from ADLS to Data verse table. We have a Look up column in that table. Need to insert data into that column based on other column.

Ex:

We have name, value, reference, code, id, Parent id columns in dataverse.

Source adls has name, value, reference, code columns.

Id is guid column auto generated.

we need to look up on the value column and see the reference column values are present in value column in (any row) and if value column data matches reference column data in any row , then the id value should be inserted in parent id column.

This process am doing with ADF mapping data flows.

Facing issues while checking the look up of value and reference columns

Answer 1

Hi @Mallikarjun appani

You can follow a similar approach to implement lookup and do a update as needed using CASE function in derived columns. (Please note this is just a reference example and you will have to tweak a bit as per your implementation, but the implementation flow remains same)

Ref Q&A thread link: ADF Assert transformation - check if a value exists in lookup table

Hope this info helps.

Thank you