Required data from second input file to first inout file

[Maheshp]

Hi Team,

I am preparing a workflow, where in we need some line items from second input file to first input file.

As you can see in below chart, a & b are the names of person, 3 & 4 columns are Unique code & amount, same we have in second file but there are some extra transactions in first file, but we want only those data where the data is existing in first file from second report, so is there any criteria wherein we can pick the data. And in front of extra data, it shows us as an NA.

Data in first input	Want data from second input to first input file.
a	b	Unique Code	Amount	Unique Code	Amount
xx	yyy	3	4	3	4
z	q	1	2	NA	NA
e	a	2	3	2	3
t	d	3	4	NA	NA
u	f	7	5	NA	NA
i	h	5	5	5	5
j	t	6	6	6	6

Regards,

Mahesh

[ed_hayter]

I am a bit confused by the request. Would a join work where we join on unique code and then union on the unmatched outputs from input 1

[Maheshp]

Hi,

When we join it will segregate between L J R also all the data will come together, but i want only two columns in first input file. As in both the files there are numbers of column and i needed only two columns from the second input file.

Regards,

Mahesh

[ed_hayter]

So in the join tool you can configure what columns you want to keep.

I think I need a clearer example of the fake inputs and what you want out of them. the ones in the post are a bit confusing.

The union is intended to bring the data back together and a union of L and J gives us all rows from the left anchor with the additional columns when they match otherwise NULL