Hi all
I have a data set that I am splitting into two steams, one to format the original set and another to summarize the original set (essentially sum-iffing in the summarize stream).
I want to then recombine the two streams with the summarized stream basically being pasted two columns after the formatted stream
However when I do the union it is positioning in the correct column (say column z) but it is starting after the last row of the first stream, so instead of positioning the summarized data starting in z2 it is starting it in z300
I believe the reason is that it is splitting the data in two rows in the union tool
Ideally there would be no #2 row I guess
I hope this makes sense - is union the wrong tool?
Dave
Solved! Go to Solution.
Hi @Dave
Thats how union tool works. For your usecase you might need to implement more logic. Can you provide some sample input and expected output file we will be able to help you out.
The files have protected info but essentially it is the following
Original file
Summarize data in separate stream
output to new file
I basically want to combine the summarized data and the original file as above and output a new file
Hi @Dave
Here is how you can do it. I summarize tool I am using name followed by space.
Workflow:
Hope this helps : )