Compare same column name in 2 different sheet

i want to compare 2 different excel sheets having column name same

capture1 image having rows 5 means ABCD.XLSX
Capture2 image having row 8 means EFGH.xlsx
In capture1 image, i want to compare column Name value abcd with column Names in different excel having value abcd so its Matched(capture2 image)
for next item in In capture1 image, i want to compare column Name value edfg with column Names in different excel having value abcd so its Not Matched(capture2 image), so it will check for another row in another excel sheet(capture2img), value is qqqq , so again its not matched
so it will check for another row in another excel sheet(capture2img), value is edfg , so its now matched

Capture2 Capture1

Hi @Ananya1

1.Create two data table variables DT1 and DT2.
2.Use for each row pass DT1 and then use another for each row activity pass DT2.
3.Use If condition compare row(“DT1ColumnName”).contais(row(“DT2ColumnName”)).

Regards,
Kommi Jeevan.

2 Likes