Update columns of DT from Dictionary Variable (Columns are different)

Help Studio
, , , , ,
1

Hello all,

DT1 (DT to be updated)

image
image1010×148 5.47 KB

Dictionary variable (values to update from)

image
image1108×112 4.25 KB

Scenario 1 -
DT1 should be updated if Number column matches to BDR column (update same row)

Scenario 2-
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

image
image947×124 5.48 KB

Excepted O/P for Scn 2

image
image1079×137 6.72 KB

@ppr

Thanks

2

Hi @Athawale_Rushikesh Good Morning
In Scenario 1 what is the value you want to update?

3

Hi @raja.arslankhan

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

4

Hello @Athawale_Rushikesh

Can you please share the expected output for the 2 scenarios in an excel? That will give more clarity to your requirement.

Thanks

5

Hi @Rahul_Unnikrishnan

I have updated the original post with expected output for both scenario.

Thanks