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. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to append rows from one table to rows of another

ai5703
5 - Atom

I have 2 tables where I'd like to append/add the rows from one into another table. However One table has a subset of the columns. Any suggestions?

Fror example

Table A: has columns A thru E. The table has 15 rows

Table B: has columns A thru C. It has 10 rows

 

The resulting table should have 25 rows with no values for the new cells from table B.

 

Another example as above would be 2 outputs from a joint operation like the Left output and Joined output

10 REPLIES 10
davidi722
6 - Meteoroid

use union tool, connect both files to union tool.

Labels
Top Solution Authors