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. 

Frame.xlsx

SIM_Monthly_Shipments.xlsx

SIM2_BookingsWith Frame.yxmd

Luke_C

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.