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