topic Help needed....dropping an intermediate table drops the derived table too in QlikView

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

Thu, 09 Jun 2011 21:07:33 GMT

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

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

johnw — Thu, 09 Jun 2011 21:35:26 GMT

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.

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

Thu, 09 Jun 2011 21:36:25 GMT

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.

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

Thu, 09 Jun 2011 22:04:35 GMT

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

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

Fri, 10 Jun 2011 06:23:54 GMT

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