DT1 (DT to be updated)
Dictionary variable (values to update from)
Scenario 1 -
DT1 should be updated if Number column matches to BDR column (update same row)
To append the row from Dictionary var to DT1 if BDR does not match (Columns are different and mapping of columns are available)
Expected O/P for Scn 1
Excepted O/P for Scn 2
Hi @Athawale_Rushikesh Good Morning
In Scenario 1 what is the value you want to update?
All the columns you can see in DT1 from dictionary variable i.e table 2
Mapping is exactly same as per column shown in both table.
Both tables having 9 columns
Can you please share the expected output for the 2 scenarios in an excel? That will give more clarity to your requirement.
I have updated the original post with expected output for both scenario.