How to store concatanated tables

[Anonymous]

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

[jubarrosor · Accepted solution]

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

[sasiparupudi1]

you will have to use the store command

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

[Anonymous]

Thanks Juan

It worked 🙂

Regards

Abhijit