Compare two columns from different excels and fetch the output from another column where there is a match

Help StudioX
,
1

Hi,

I need to compare two columns from first excel with two columns from second excel and if the data in first excel matches with second excel, then the output has to be taken from the another column in the second excel.

Lookup data table can be used to compare only one common column, I’m not sure in this case.

Please help me on this as which activity i need to use.

2

Have a look at the Join DataTable activity

1 Like
3

Hi @radhikam.kumar,

I am sharing a previously opened example and a link for you to follow. I hope it helps.

Regards,
MY

1 Like
4

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