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 

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

Workflow:

Hope this helps : )

tables sidebyside.yxmd