Multi Field Formula to Compare Columns

[BrandonS4]

I am trying to use the Multi Field formula to compare columns after I have joined them together.  I want to create a formula that says if the columns match, return "True" and if they do not match, return "False".  I have attached a sample of my data.  Any help would be appreciated!

Thanks!

[Kenda]

Hey @BrandonS4 

I'm sure, like many Alteryx problems, there are many ways to get to what you're looking for. I have attached one example. I often find Transposing data then Cross Tabbing it back to be helpful when looking at data.

Hope this helps!

[BrandonS4]

@Kenda This works, however I have 40 columns total to compare (20 from the right and 20 from the left)

[Kenda]

@BrandonS4 

I thought this might be the case. That is why I transposed the data first. This should allow for a varying number of fields. What issue are you still running into?

[echuong1]

Take a look at this article for sample workflows and reports:

https://community.alteryx.com/t5/Engine-Works/Compare-2-Data-Sets/ba-p/88853 

[BrandonS4]

I have two sets of data being pulled in using a Wildcard Input.  Each file has 118K lines of data.  I joined them together using the Join tool and I have zero records from the right and zero from the left since everything joined together correctly.  I then want to make sure none of the joined values have different values.  When I attach your workflow from my join, after the join in your workflow I have zero records joined together.