Multi Field Formula to Compare Columns

Question

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!

Multi Column Formula.xlsx

BrandonS4 · Answer

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.

echuong1 · Answer

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

Kenda · Answer

@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?