Help needed....dropping an intermediate table drops the derived table too

[#1]

Hello,

In Qlikview load script, I have three tables A,B and C. C is derived from A and B. Now I am creating another table D based on these three tables. Now i no longer need table A, B and c so I used drop statement like

Drop table A;

Drop Table B;

Drop Table C;

Now what i am seeing here is that table D has also disappeared even though i did not drop it. Can anyone help what might be happening here

Arif

[johnw · Accepted solution]

If table D has the same fields as another table, then you don't actually have a table D, but instead QlikView has  concatenated the table D contents onto one of the other tables.  To avoid this, when loading D, use NOCONCATENATE.

😧
NOCONCATENATE
LOAD ...

Not that that's the only possible problem, but it's probably the most common.

[#3]

Could you post a sample of your script? My initial thought is that there is some logic in your script to generate table D which is failing thus preventing it from loading?

Try the same script with the drop statments commented out & see what (if anything) is being generated there for all of your tables.

[#4]

yeah it works, when i dont drop those previous tables. It only disappear when i drop the prevoios couple of tables. I believe that the problem might be the one which john just mentioned. I will confirm it in my script and then verify the answer if it works.

Arif

[#5]

Wonderful, Thanks Leanard and John for the help. John was right. When I used the NOCONCATENATE, the script is no more removing it from model

Arif