Save to QVD - Table not found?

[#1]

I have a QVW from which I am trying to save some tables to QVD. I'm certain the tables exist in the QVW (the data is there) but I get 'Table not Found' when trying to store to QVD. I'm sure it must be something extremely obvious that I am missing (yes the table names and upper/lower case are exactly the same). Any ideas? Anybody else come across this ?

Any help much appreciated. And feel free to call me an idiot if my syntax is wrong!

Cheers.

A couple of screen shots...

[#2]

Hi liberated,

         Before save the table you have to load then, move the save statement after the load statement.

i hope to help you.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

The STORE sentence must always be after a LOAD statement. In QlikView, the script is always run sequentially, from the first line at the top of the first tab to the last line in the last tab on the right.

In your script, though, you are calling to STORE a table that is still not been loaded, therefore the error.

Place the same line of code after the corresponding LOAD and that will work just fine.

Hope that helps.

Miguel

[#4]

Aah yes of course! A bit of a brainstorm today I think, thanks guys!

[#5]

if yo use two script load , all column are similar name you take this error. İn an other words, think union script

script1

union

script2

this situation you must use concatanate or noconcatanate ,

table1:

script1 ;

noconcatanate ,

table2:

scrip2;