Joining multiple result sets

Question

So I have 2 union outputs from the same source file

First output - 77,000 Records and 33 Fields

Second output - 76,000 Records and 34 fields

33 Fields are the same - I want to join these two inputs together with the 34th field. The field PO number is common between these inputs. But when i join with PO Number in Join by specific fields input - the result is someone over 150,000 records.

My input of 77,000 gets lost. How do i join the unions outputs and add the 34th field and maintain the same number of records

I hope i am making sense here.

AbhilashR · Answer

Hi @Abhii2658, going by your note I think you need to use the join tool which will look something like this,

while the screenshot you have is that of the Union.

If it helps, the Union tool stacks one dataset beneath the other and aligns the data based on column header names, while the join tool stacks data one beside the other based on the column you use to join them (PO in your case). The one caution about Joins is that, you need to make sure you join the datasets on a column that has a unique 1:1 mapping between the datasets, else you will get duplicates.

Hope this helps.