topic Re: Multi Field Formula to Compare Columns in Alteryx Designer Desktop Discussions

Multi Field Formula to Compare Columns

BrandonS4 — Mon, 09 Nov 2020 19:20:34 GMT

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!

Re: Multi Field Formula to Compare Columns

Kenda — Mon, 09 Nov 2020 19:39:18 GMT

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!

Re: Multi Field Formula to Compare Columns

BrandonS4 — Mon, 09 Nov 2020 19:46:38 GMT

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

Re: Multi Field Formula to Compare Columns

Kenda — Mon, 09 Nov 2020 19:57:22 GMT

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

Re: Multi Field Formula to Compare Columns

echuong1 — Mon, 09 Nov 2020 19:58:15 GMT

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

Re: Multi Field Formula to Compare Columns

BrandonS4 — Mon, 09 Nov 2020 20:02:22 GMT

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.