Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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
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