Vlookup using UiPath

[Palaniyappan (Palaniyappan P)]

Buddy @Selvasathya

In that case you use join datatable activity in UiPath, where you can pass the first datatble and second datatable and make join with names as inner join and get the final output datatable separately.

hu
this can give you a fine idea about using join table

Merge two datatables with common column

Hi i would like to use merge datatable activity but would like to ask what would happen if both datatables only have one common column, and i would like to merge all columns according to that common column. eg. Table 1 Name Age A 11 B 12 Table 2 Name Address A USA B UK to become Table 3 Name Age Address A 11 USA B 12 UK

Else if you want to use vlookup, we have an option called lookup datatable activity where you can pass the column Name as lookup column in the property and check with first excel datatable, but my kind suggestion is to take the first option, that would work

Hope this would help you

Cheers