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: 
Not applicable

Append Two Resident Tables into a New Table

I created two resident tables: T1_Active3 and T2_Term3.  I want to append the records from T1 and T2 into a new table called T5_Retention Detail.  I tried the following script, but it did not work.  I've attached the qvw file and edata.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

.... maybe try this at the end of script :

T5_Rentention_Detail :

NoConcatenate

Load * resident T1_Active3;

Concatenate

Load * resident T2_Term3;

drop table T1_Active3;

drop table T2_Term3;

View solution in original post

13 Replies
Anonymous
Not applicable
Author

Do you mean to have a space between T5_Retention and Detail ?


Or should it have been an underscore ?

Anonymous
Not applicable
Author

.... maybe try this at the end of script :

T5_Rentention_Detail :

NoConcatenate

Load * resident T1_Active3;

Concatenate

Load * resident T2_Term3;

drop table T1_Active3;

drop table T2_Term3;

Not applicable
Author

I revised the syntax.  The syntax loads without error, but I see only the two resident tables in the table viewer, I don't see the newly created table T5_Retention.  If I drop the two resident tables I see no tables in the table viewer.

   

Not applicable
Author

I'm going to test your script now.

Anonymous
Not applicable
Author

I added the NoConcatenate to sort that.

Not applicable
Author

The syntax from your original response worked perfectly.  THANKS SO MUCH !!

maxgro
MVP
MVP

try this

T5_Rentention_Detail:

NoConcatenate

Load * resident T1_Active3;

Concatenate (T5_Rentention_Detail)

Load * resident T2_Term3;

drop table T1_Active3;

drop table T2_Term3;

in your script this will autoconcatenate to T1_Active3 because you're loading the same number and names of fields

T5_Rentention_Detail:

Load * resident T1_Active3;

Anonymous
Not applicable
Author

No worries - glad you are on the road again.

Not applicable
Author

Thanks Maxgro and Bill.  Your scripts work perfectly, but I don't understand why the Noconcatenate is needed if I'm trying to concatenate (append) records ?