Matching Fields based on Matching ID - Finding differences?

[BruceWillis]

Hi Team,

I am wondering if you could advise? I am looking to generate a reconciliation (below example) whereby matching IDs (key) should have the same size adn unit, to break out any exceptions to that rule.

What is the correct articulate this in Alteryx? 

Example below: the Alteryx check is, if keys that match, do the size and unit? Y/N

Any help would be appreciated 

Brucey

[zajaccount · Accepted solution]

Hi

I managed to do this using 3x multirow formulas (the third one could also be a standard formula tool if you prefer I guess).

Please let me know if this works for you.

[BruceWillis]

Great thanks! Worked perfectly for me 🙂

[zajaccount]

Great, glad I could help!😉

Please mark it as the solution so that others can find it more easily 😉