Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

paste append for different content

Highlighted
8 - Asteroid

In table 1 the sales $ is ranked descending for each Category

CategorySales
Apple1000
Grape800
Orange600

 

In table 2, the Budget $ is ranked ascending for each Category.

CategoryBudget
Banana650
Grape900
Orange1050

 

Is it possible to union these two tables together as below in one sheet for the same file?  Thank you.

CategorySales
Apple1000
Grape800
Orange600
CategoryBudget
Banana650
Grape900
Orange1050
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

You can UNION the data together easily.

 

Change the "Auto Config by Name" option to:  Manually Configure Fields.

 

Note:  AutoConfig by Position will work too in your simple case.

 

The output won't have the "column headers" included, but the data will be merged in the output.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
12 - Quasar
12 - Quasar

One option is to use the Table and Render tools to stack the tables in an output.

 

render.png

Labels