Compare two columns from two different sheets, For matched item, Copy values from corresponding cells and paste it in sheet3 . For non-matched, cut/paste the whole row to sheet4

Help Activities
, ,
1

Compare two columns from two different sheets, For matched item, Copy values from corresponding cells and paste it in sheet3 . For non-matched, cut/paste the whole row to sheet4

2

@ayushi_jain3

You can read both the tables…and then use join datatable activity and get the matched and non matched rows separately

Check this for more details

You have to do full join and later use filters in one go to get

Cheers