Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Matching Fields based on Matching ID - Finding differences?

BruceWillis
6 - Meteoroid

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

 

BruceWillis_0-1589803065105.png

 

Any help would be appreciated 

 

Brucey

3 REPLIES 3
zajaccount
9 - Comet

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
6 - Meteoroid

Great thanks! Worked perfectly for me 🙂

zajaccount
9 - Comet

Great, glad I could help!😉

 

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

Labels