Is there a way to stack dissimilar data?

[marcus]

I want to combine two streams with dissimilar data into a single final output excel sheet. I feel like this should be easy but it's eluding me. In excel I would use VSTACK to accomplish it.

EE ID	Name
1	EE Name 1
2	EE Name 2
3	EE Name 3
4	EE Name 4
5	EE Name 5
Office ID	Location
1	Location 1
2	Location 2
3	Location 3
4	Location 4
5	Location 5

[Luke_C · Accepted solution]

Hi @marcus 

You could try a union tool and set it to auto configure the columns by position

[Yoshiro_Fujimori]

Hi @marcus 

I guess Union Tool would server for the case.

Help page:

https://help.alteryx.com/current/en/designer/tools/join/union-tool.html

Interactive Lesson:

https://community.alteryx.com/t5/Interactive-Lessons/Blending-Data-with-Unions/ta-p/76632

I hope this helps. Good luck.

[marcus]

Thank  you. Union does work, but II have to do a work around to add a blank line in between and the header of the second stream.