Concatenate Tables

[gfisch13]

Hi - I'm trying to concatenate a pair of tables.  The following are my lines of script which are generating 'file not found' error messages.

Combo:

LOAD DATA_SRC_CD, Month, Year, TRAN_AMT FROM Amex;

Concatenate

LOAD DATA_SRC_CD, Month, Year, TRAN_AMT From Citi;

Combo is the name of the new table I'd like to create, Amex and Citi are names of tables I've loaded earlier in the script.  What am I doing wrong?

[vishsaggi]

Try this? Is your file Citi in that location? is that an excel file?

Combo:

LOAD DATA_SRC_CD, Month, Year, TRAN_AMT FROM Amex;

Concatenate(Combo)

LOAD DATA_SRC_CD, Month, Year, TRAN_AMT From Citi;

[swuehl · Accepted solution]

Is it really a file you want to load the data from? Or a RESIDENT table from your data model (i.e. you already loaded the data from a source in a previous LOAD statement)? If latter, use

...

RESIDENT Citi;

[gfisch13]

Thank you Stefan!!!

[gfisch13]

Thank you Vishwarath!!