I have Two data tables DT1 and DT2 . I am comparing this two data tables respect to DT1 if DT1 Coulmn value equal to DT2 Coulmn value i want DT2 corresponding second coulmn value for update Excel sheet how to do pls anyone help


Please try using “Join Data Tables” activity for joining DT1 and DT2 and followed by “Lookup Data Table” activity for fetching the second column value.


1 Like

Use left join for DT1 and DT2. You will get all row from DT1 and rows matching with DT1 from DT2 will get merged with DT1 as new columns.

1 Like

Thanks! @Kalpesh_Chaudhari

1 Like