Row Comparison

[DannisMen]

Hi, 

how can i made a row comparison and have a third row to be 1 or 0 (matched or not matched) for all columns?

it would be awesome just using one tool. 

thanks.

[echuong1]

If you want to check to see if all values match for every row, you can do a Join and use every field as the join criteria. Anything that matches 100% would come out of the J output. Anything different would come out of L and R.

You can also pivot your data to have the values vertically, and then use a formula for the difference. 

See attached for examples of both.

Hope this helps!

[bpatel]

hi @DannisMen ,

Here is what i came up with. Couldn't do it with one tool but hope this helps!

[DannisMen]

Hi thanks for your help. 

there is one slight change in my data. now i have to compare the last two rows which is total before/after filters. 

in this case, your solution may not work.

[echuong1 · Accepted solution]

You can add a filter for the two lines you'd like to compare prior to the rest of the workflow.

I think the first approach is more useful because it isolates the exact fields.