In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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
19 - Altair
19 - Altair

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