Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Two Outputs to join with blank lines between

hendricksk
6 - Meteoroid

Is there a way to join two excel Outputs and insert two blank lines in between the two different data sets?

 

2 REPLIES 2
apathetichell
19 - Altair

sure.

 

you can make 3 tables using the table tool. create sort ids - use union - sort by ids. use a summarize tool to join them into one vertical object. use render.

 

you can create a text input tool with two empty lines. you can use union by position to union all 3 datastreams. do the same kind of thing with sort ids -  use output data.

hendricksk
6 - Meteoroid

Thank you!

 

Labels