Union tool - position union of second data stream

[Dave]

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

[atcodedog05]

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.

[Dave]

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

[atcodedog05]

Hi @Dave 

Can you provide the excel so that i can copy the data.

[Dave]

sure - see attached, and thank you 🙂

[atcodedog05 · Accepted solution]

Hi @Dave 

Here is how you can do it. I summarize tool I am using name followed by space.

Workflow:

Hope this helps : )