Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to store concatanated tables

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

1 Solution

Accepted Solutions
jubarrosor
Partner Ambassador
Partner Ambassador

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

View solution in original post

3 Replies
jubarrosor
Partner Ambassador
Partner Ambassador

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
Master III
Master III

you will have to use the store command

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

Anonymous
Not applicable
Author

Thanks Juan

It worked 🙂

Regards

Abhijit