In this case you just have to add the "concatenate" function between both tables. It will "add" table B below table A. If you have the same records in both tables they will be duplicated. If you don't want to duplicate records, check out the 'join' functions (left join, right join,..).
As others indicated, you can add the Concatenate prefix to the TableB load to force the rows to be appended to TableA. An important note, if you run your script as you posted, without "Concatenate", you will see no TABLEB in your data model. When the fieldlist in a LOAD statement (TABLEB) is the same as an existing table (TABLEA), automatic concatenation will occur. You will find all your rows in TABLEA and there will be no TABLEB.
In this case you just have to add the "concatenate" function between both tables. It will "add" table B below table A. If you have the same records in both tables they will be duplicated. If you don't want to duplicate records, check out the 'join' functions (left join, right join,..).
As others indicated, you can add the Concatenate prefix to the TableB load to force the rows to be appended to TableA. An important note, if you run your script as you posted, without "Concatenate", you will see no TABLEB in your data model. When the fieldlist in a LOAD statement (TABLEB) is the same as an existing table (TABLEA), automatic concatenation will occur. You will find all your rows in TABLEA and there will be no TABLEB.
