Cell by cell comparision

Question

hi guys, I have 2 datasets to compare.

I join them using " Account Number" to see new accounts that showed up and account that fell off from the previous week.

Then on record that stays, I'm doing a cell by cell comparison to see if any characteristics have changed.

The problem is I have about 114 columns so doing a true/false comparison is a pain.

I have something like this but repeat 114 times.

Then I have to filter all of the "_Difference" columns.

is there a better way to do this? something like dynamic formulas on multiple fields and filtering the same criteria on multiple fields.

Thank you!

Qiu · Answer

@hannah201089

Thank you for the feedback.

This one ok?

1208-hannah201089.yxmd

hannah201089 · Answer

hi @Qiu

Almost! Except after I join my 2 datasets, I have to manually rearrange each set of columns so that they're next to each other right? I have more than 100 columns so it's quite a pain. Is there any ways I can dynamically re-arrange left and right columns to be next to each other like the sample you have?

Desired output

Mine

I would like to maintain the original order from the source file

kelsey_kincaid · Answer

Hi @hannah201089 ,

I would recommend transposing each data source, then joining on Account Number & Name. From there you can compute how many data points match/mismatch for each row. Would something like this work?

MultipleMatches.yxmd