How to compare 2 rows and return the incorrect non matching fields

Question

I need to compare 2 rows and return the columns which are not matching.

Basically , its a validation of rows from different datasets ,I will be joining the rows based on a common column ,
if there is any difference in the row values when it's compared with the other row , I will return the column which is not matching

gawa · Accepted Answer

hi @sumeet_rk

When comparing the row, the best practice is to Transpose data into vertical shape, Join, and check difference by Filter tool.

As we are not sure of always having the same data schema in the most of real case, this method is generic solution to cater for such a scenario.

Please refer to the attached WF for reference and understanding what I meant to say.