How to append rows from one table to rows of another

[ai5703]

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

[MarqueeCrew]

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

[Ned · Accepted solution]

I think you are looking for the Union tool.

[ai5703]

I found the same amswer riding the bus home. Thanks

[ai5703]

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

[NilM]

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]

I posted this reply to the wrong topic. 

Cheers,

Mark

[NilM]

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 Title	Budget
A	1000
B	2000

Data set 2:

Movie Title	Budget
C	3000
D	4000

The new data set should be:

Movie Title	Budget
A	1000
B	2000
C	3000
D	4000

There must be an easier solution to this? Thanks!

[MarqueeCrew]

It is as easy as @Ned said...

Cheers,

Mark

[NilM]

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