Appending two tables

[MikeGaunt]

Hi All, 

I need to Append to tables stacking the rows on top of each other. 

The column heading will be different in each Table. 

Table 1 

Table 2 

I need to add the data from Table 2 to Table 1 according to the following 

If this creates a 3rd master table no issue .

I have no idea where to even start. Script thus far for table 1 is attached. 

[sidhiq91]

@MikeGaunt You can write script something like below:

Noconcatenate

Table1:

Load * from Table1;

concatenate(Table1)

Load * from Table2;

Please let me know if you are looking for something else.

[SchalkF]

Load * won't work for the below screenshot where he wants the 2 tables to "join":

If you want these fields to align in the same columns in your new table, you need to set the field names of table 2, to the same as table 1 like below:

Combined:
Load *
from Table1

Concatenate(Table1)
Load
          [Purchasing Document] as SO,
          [Item] as [Sales Document Item],

.........

From Table2

Though your data is actually not the same since you are trying to concatenate Purchasing Documents with Sales Documents, but this will give you your desired effect I believe, so just play around with that, if you just wanted everything to be in one table, disregarding that them being in the same fields, then you can use the Load * for both tables and have all the data in one table, with Null values for the Purchasing fields for Sales records, and Null in the Sales fields for Purchasing records

Kind regards