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
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
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