Lookup two data tables

[aishwarya1 (Aishwarya)]

Hi,

I have a data table DT1 with column Account and Cust Name, another data table DT2 with Account_No, Name.

I want to lookup the Account_No of DT2 with Account of DT1 and populate the respective cust name in the column “Name” in DT2

Please let me know how to achieve this

[Palaniyappan (Forum Leader)]

Hi

Have a view on this activity and it has also got some example on how to use it

Let us know if you are facing any issues in that

Lookup Data Table

Cheers @aishwarya1

[muhammedyuzuak]

Hi @aishwarya1,

You can follow this link. There are detailed explanations and examples.

How to lookup two data tables?

Hi, I have 2 excel sheets, one with 4 rows and other with 6 rows, I want to get all the rows from sheet1 and the not matching extra rows from sheet2 and paste the combination of both in sheet3. please assist in how to achieve this scenario… thank you so much in advance.

Regards,
MY

[Rahul_Unnikrishnan]

Hello @aishwarya1

If you directly want to work in excel itself, you can use VLookup activity and if you want to work with the datatable you can use Lookup Datatable activity. Please refer the below docs.

VLookup

Lookup Data Table