How do I compare data in two excel sheets when the headers are different?

Hi there !

When the headers are same, we can use lookup data. But when the headers are different, how I compare the data in two sheets ?

I have attached the snap of the sheets :-

1 Like


Welcome to uipath forum

We can still use lookup datatable activity if the column names are different
As we are going to pass the Target ColumnName and Lookup column name along the property of that activity

So it’s fine if the column names are different

Have a view on this activity for an example

Cheers @uio

1 Like

Hello @uio

You can provide the column index. Its not mandatory to use Column Name and it has no relevance in vlookup. You can use the below activity to directly do the lookup with the excel.

Join datatable can also be used.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.