EXCEL DATA TABLE DOUBT

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

@BHUVAN

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.

Cheers

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