Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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