topic Re: How to store concatanated tables in QlikView

How to store concatanated tables

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

Hi All,

I have 3 tables with a common Primary_ID and a flag field to distinguish the IDs.

I have concatenated the all the 3 tables, however wanted to how I can store the data into 1 table.

Below is the script :

Table_A:
LOAD
Transaction_ID as Primary_ID,
'Y' as T1_ID

FROM

(qvd);

Store Table_A into C:\Users…\Extract\T1ID.qvd;

Concatenate(Table_A)
LOAD
Tran_ID as Primary_ID,
'Y' as B1_ID
FROM

(qvd);

Concatenate (Table_A)
LOAD
Primary_ID,
'Y' as C1_ID
FROM

(qvd);

Thanks and Regards

Abhijit

Re: How to store concatanated tables

jubarrosor — Wed, 18 Apr 2018 08:20:12 GMT

Hi Abhijit:

You must store the table after the last concatenate:

Table_A:
LOAD
Transaction_ID as Primary_ID,
'Y' as T1_ID

FROM

(qvd);

Concatenate(Table_A)
LOAD
Tran_ID as Primary_ID,
'Y' as B1_ID
FROM

(qvd);

Concatenate (Table_A)
LOAD
Primary_ID,
'Y' as C1_ID
FROM

(qvd);

Store Table_A into C:\Users…\Extract\T1ID.qvd;

Best Regards,

Juan P. Barroso

Re: How to store concatanated tables

sasiparupudi1 — Wed, 18 Apr 2018 08:26:52 GMT

you will have to use the store command

Store Table_A into C:\Users\mishraab\...\Extract\Table_A.qvd(qvd);

Re: How to store concatanated tables

Anonymous — Wed, 18 Apr 2018 08:44:10 GMT

Thanks Juan

It worked 🙂

Regards

Abhijit