Join causing data records to go from 6,343 to 31,294

[Karl_Spratt]

Hi Community,

Need some help please I have a bookings data file, I need to pull in from a different excel file the Business division, SIOP SEG-5, Frame where these join with the siopseg5 on my input file,  ( True join) then an un-joined records from my input I also want to keep in my WF, so I have a union tool after my join.

But the Join causing data records to go from 6,343 to 31,294

Attaching samples of input file,, the Frame File and the Output I'm getting,  Also pictures of the join I'm using, all I'm saying is if both files match give me the true,, and if both don't jive me the input un-joined records. 

Any help would be greatly appreciated

TIA,

Karl 

[atcodedog05 · Accepted solution]

Hi @Karl_Spratt 

You can use find and replace. Find and replace will work like excel vlookup (full left join) and create no duplicates.

Hope this helps : )

[Karl_Spratt]

Hi  atcodedog05, that worked perfectly thank you

[atcodedog05]

Happy to help : ) @Karl_Spratt 

Cheers and have a nice day!