LOAD statement

[marco_puccetti]

Hello, i've noticed that when i make a load of some datas, is generated the qvd (with store command) but the table in-memory is not created, is it possible?

Thanks

Marco

[marco_puccetti]

Another question is related to this statement:

let noRows = NoOfRows('InstagramSites'), this statement returns NULL (I have replaced the Instagram Sites in order to let it work).

The table is defined in a config file located like this:

$(Must_include=C:\Users\m.puccetti\Desktop\LAVORO\QLIKVIEW\DEMO\Social Media Analyzer\SETTINGS\config.txt);

And within the config, the table is defined like this:

// Instagram parameters

InstagramSites:

LOAD * INLINE [

tpage, tSite

999999999999999, Bancadinamica

];

I have debugged the script and i've seen that the config is linked to the code, so it should work.

Any ideas?

Marco

[marco_puccetti]

Now the table is loaded thanks to the qvd creation.

Marco

[petter]

QlikView Reference Manual (English) PDF:

Page 289 - Chapter 24 - Script Syntax has two or more pages of explanation and example of the use of ErrorMode and ScriptError.

[petter]

When you get a Null-value from NoOfRows(<tablename>) then there is no <tablename> table to count the rows in.... If the table exists then it would give 0 or more as a value.

[timanshu]

Kindly mark most helpful reply as answer. It will help others to find the answer of what they look for.

[marco_puccetti]

The table is created in the config file, but it seems not to be included in the script.

Marco