topic Re: Append Two Resident Tables into a New Table in QlikView

Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 17:46:56 GMT

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.

Re: Append Two Resident Tables into a New Table

Anonymous — Fri, 18 Nov 2016 17:53:11 GMT

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

Or should it have been an underscore ?

Re: Append Two Resident Tables into a New Table

Anonymous — Fri, 18 Nov 2016 17:56:49 GMT

.... 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;

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 17:56:50 GMT

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.

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 17:58:01 GMT

I'm going to test your script now.

Re: Append Two Resident Tables into a New Table

Anonymous — Fri, 18 Nov 2016 18:00:09 GMT

I added the NoConcatenate to sort that.

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 18:03:44 GMT

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

Re: Append Two Resident Tables into a New Table

maxgro — Fri, 18 Nov 2016 18:04:26 GMT

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;

Re: Append Two Resident Tables into a New Table

Anonymous — Fri, 18 Nov 2016 18:06:30 GMT

No worries - glad you are on the road again.

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 18:09:06 GMT

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 ?

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 18:17:02 GMT

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

Re: Append Two Resident Tables into a New Table

Anonymous — Fri, 18 Nov 2016 18:17:31 GMT

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.

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 18:19:39 GMT

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

Re: Append Two Resident Tables into a New Table

Fri, 18 Nov 2016 18:24:38 GMT

I understand now, thanks so much.