Vlookup and joining reports

Hi Friends…two excel reports are being joined using vlookup. Is there any way to do it using uipath? I tried with inner join and full join. But in both ways, their requirement is not matched. Can anyone please help?

@Ananya_Ghosal Can you provide the Input Excel files and the Output Excel that you Expect? If Confidential you can replace the Data with the sample data but keeping the Headers and the format as it is.

Hi @Ananya_Ghosal

You can go with a datatable select query to retrieve information from both datatables. if you want more information please elaborate your use case.

1 Like