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

[Karl_Spratt]

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. 

[Luke_C · Accepted solution]

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. 

[Karl_Spratt]

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

Cheers,

Karl