Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Join is adding 2.% K records to my file why?

Karl_Spratt
8 - Asteroid

Hi Community,

 

Need some help please I'm trying to do a lookup using a join to say if this description is in one file bring back the frame size based on the description   So I have a booking file with 14K records, when I do the join it's adding 2.5k records, 

I can't understand why. 

 

I've attached the sample data files and a copy of the WF logic I used, its a simple join but I don't understand the reason for the increase. 

If someone can advise the reasons why.

TIA 

Karl. 

2 REPLIES 2
Luke_C
17 - Castor

Hi @Karl_Spratt 

 

In Frame.xlsx, some descriptions are in there multiple times. See below example. When you join, any records in the data with that description will be there however many times they are in the frame file. Your best bet is to either make the description column unique or join on a 2nd attribute. 

 

Luke_C_0-1634598005577.png

 

Karl_Spratt
8 - Asteroid

Tanks Luke, I will try find another unique join Key.

Cheers,

Karl

Labels