Cell by cell comparision

[hannah201089]

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!

[christine_assaad]

hi @hannah201089 

I am not sure how your data looks like but you can perhaps use the Transpose building block to get everything in rows instead of column so one single formula could be applied across all records.

If you can send some data samples, that could help. Thanks!

[Qiu]

@hannah201089 

Would this be acceptable for you?

Or we can do something more?

[kelsey_kincaid]

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?

[hannah201089]

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

[Qiu]

@hannah201089 

Thank you for the feedback.

This one ok?