topic Re: Concatenate Tables in QlikView

Concatenate Tables

gfisch13 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Concatenate Tables

vishsaggi — Tue, 31 Jan 2017 19:12:03 GMT

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;

Re: Concatenate Tables

swuehl — Tue, 31 Jan 2017 19:13:13 GMT

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;

Re: Concatenate Tables

gfisch13 — Tue, 31 Jan 2017 19:33:16 GMT

Thank you Stefan!!!

Re: Concatenate Tables

gfisch13 — Tue, 31 Jan 2017 19:34:00 GMT

Thank you Vishwarath!!