Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
MarqueeCrew
20 - Arcturus
20 - Arcturus

I'm sorry but I don't understand the problem. Could you please mock up the tables and output?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Ned
Alteryx Alumni (Retired)

I think you are looking for the Union tool.

ai5703
5 - Atom

I found the same amswer riding the bus home. Thanks

ai5703
5 - Atom

Here is an example. But I think the answer is the union tool as Ted eluded below.

 

NilM
6 - Meteoroid

Hello,

the Union tool does not seem to work for me here. It does not append the additional data from the second data set. Same goes for the joint tool. I really ran out of ideas what to do here. See workflow attached.What am I doing wrong? :(

 

Greets,

Nils

MarqueeCrew
20 - Arcturus
20 - Arcturus

 

I posted this reply to the wrong topic. 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
NilM
6 - Meteoroid

thanks for your reply. But is there really no easier solution? The problem is basically really simple.

I have two date sets e.g. :

Date set 1:

Movie TitleBudget
A1000
B2000

 

Data set 2:

Movie TitleBudget
C3000
D4000

 

The new data set should be:

Movie TitleBudget
A1000
B2000
C3000
D4000

 

There must be an easier solution to this? Thanks!

MarqueeCrew
20 - Arcturus
20 - Arcturus

It is as easy as @Ned said...

 

Capture.PNG

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
NilM
6 - Meteoroid

thanks for your answer. It just realized that in the output section of the union tool not all records are displayed, therefore I did not see a change of records after using the union tool.

Now, after using the browse tool, the additional records show up. Thanks for your help.

 

Greets,

Nils

Labels