topic Re: Save to QVD - Table not found? in QlikView

Save to QVD - Table not found?

Mon, 01 Oct 2012 15:29:20 GMT

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...

Re: Save to QVD - Table not found?

Mon, 01 Oct 2012 15:38:56 GMT

Hi liberated,

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

i hope to help you.

Re: Save to QVD - Table not found?

Miguel_Angel_Baeyens — Mon, 01 Oct 2012 15:39:51 GMT

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

Re: Save to QVD - Table not found?

Mon, 01 Oct 2012 15:54:01 GMT

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

Re: Save to QVD - Table not found?

Sat, 20 Oct 2012 07:54:09 GMT

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;