We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Use Outputs of 3 Basic Table tool & combine it into one Excel sheet

vishalnegi
7 - Meteor

I am doing data massaging and as a result of this I have prepared 3 tables in 3 different Basic Table tool. Though each table follows different formatting, however each table follow same schema(i.e. same column header). I want to combine it into one table with data appended one below other along with individual formatting of each table

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

I would look at a Join Multiple to get them all on one line - you can join on Record Position if you don't have a key field to match on!  Join Multiple Tool (alteryx.com)

 

Then you use a Layout tool to stack the tables vertically

apathetichell
20 - Arcturus

I'd use a union - by position. if they are already report snippets - I'd use a summarize after to combine them into one snippet.

Labels
Top Solution Authors