Strange Script Behaviour

[pkelly]

I have a script which produces a QVD table...

If I run the script and check the data in the QVD table, it looks okay so the script is running through okay...

If I remove the store and drop table command the script hangs.

Totally confused by this - has anyone else seen this behaviour?

I am on version 9 SR5....

[disqr_rm · Accepted solution]

It may be that the table you are not dropping causing lot of synthetic keys and it is taking forever to load the links in the memory. You may want to rename the filed in this table you are dropping, or use Qualify / UnQualify to check if that could be the reason.

[#3]

Hi

I don't understand very well your problem.

After create a qvd file, do you remove the command store and drop the table that generate qvd?

Do you read the qvd file?

LOAD *

FROM MY_FILE.qvd (qvd);

[pkelly]

My script ends with....

// Create QVD Tables

STORE Receipt INTO C:\QlikViewDocuments\Timbmet_Live\QVDTables\Receipt.qvd;

// Drop Feeder Tables from Memory

Drop Table Receipt;

In my script I have created a single table called Receipt which I then output to a QVD table...

[martin59]

Hi, could you send your script ?

[pkelly]

Thanks Rakesh you put me on the right path...

I have two data extracts which I combine into one - 1 from general sales and one from point of sale.

I need to keep these two extracts identical so that they combine into one data table - there was a difference between the two.

In the past i have just ended up with two tables but this time the report just hung.

One to remember for the future.

Many thanks...