Look Up Problems

NatalieT

Hi all, I have two columns (A & .

Condition: Numbers in column A can be linked with more than one number in column B; numbers in column B cannot be linked to more than 1 unique number in column A.  I need to do an analysis on the table to check the condition above, with any numbers not meeting the conditions shown to me in a table for further analysis.  I am struggling to perform this - does anyone have suggestions? Thanks in advance!

Alteryx Look Up Question.xlsx

ShankerV

Hi @NatalieT 

Unique tool helps in this situation.

The Unique node gives the unique value from Column 2.

The Duplicate node gives the duplicated value from the column 2. 

Hope it helps!!! 

Many thanks
Shanker V

Look Up Problems.yxmd