Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.

13 Replies
Not applicable
Author

I read your response again.  You explained that the NoConcatenate removes the autoconcatenate.

Anonymous
Not applicable
Author

You are first creating a new table T5_Rentention_Detail

Without the NoConcatenate it will auto concatenate onto T1_Active3

Then because the following Concatenate is not qualified to a particular table it will also auto concatenate onto T1_Active3

Then when you drop T1_Active3 you no longer have the table as you've just dropped it.

Not applicable
Author

Perfect, thanks again,  I understand now.  I am very new to Qlikview, just taught myself in a few days, so I'm still learning. 

Not applicable
Author

I understand now, thanks so much.