topic Re: Config file inclusion in QlikView

Config file inclusion

marco_puccetti — Wed, 13 May 2015 10:10:35 GMT

Hello i need to know if the LOAD INLINE statement included in a config file are visible in the script at the reload process.

I have a table like this:

TAB:

LOAD * INLINE [

A, B

VAL1, VAL2

];

in the config file included with this statement $(include=../SETTINGS/config.txt);

but when i use this expression in the script: LET noRows = NoOfRows('TAB');

i get NULL.

Is it correct?

Thanks

Marco

Re: Config file inclusion

Gysbert_Wassenaar — Wed, 13 May 2015 10:19:40 GMT

$(include=....); will fail silently if something goes wrong.

Try $(Must_include=../SETTINGS/config.txt); to make sure that you get an error if the config.txt file can't be loaded.

Re: Config file inclusion

Gabriel — Wed, 13 May 2015 10:27:28 GMT

Hi,

As gwassenaar mentioned yes Must_Include is best option as it will alert you when it fails. However what am thinking of it why don't you test your include with full file path, the UNC path might not be right.

Re: Config file inclusion

marco_puccetti — Wed, 13 May 2015 10:56:02 GMT

Now it's working.

Thanks

Marco

Re: Config file inclusion

marco_puccetti — Wed, 13 May 2015 13:41:37 GMT

I have tried with the absolute path as you have mentioned but now it's not working in both methods.

Now the table is not visible with the LET noRows = NoOfRows('TAB'); statement.

How can i do?

Thanks

Marco

Re: Config file inclusion

Gabriel — Wed, 13 May 2015 14:05:16 GMT

Hi,

Load the Table TAB into QV , as in the script inside the txt file and use your variable noRows instead of include.

If possible share your file and the txt file for the include

Re: Config file inclusion

maxgro — Wed, 13 May 2015 15:18:08 GMT

use must_include

check in table viewer after reload the table is created

add some trace

$(must_include=../SETTINGS/config.txt);

LET noRows = NoOfRows('TAB');

trace noRows=$(noRows);

Re: Config file inclusion

Peter_Cammaert — Wed, 13 May 2015 15:23:33 GMT

Maybe you should try a path specification with backslashes (e.g. \) instead of forward slashes (e.g. /)...

Peter

Re: Config file inclusion

marco_puccetti — Wed, 27 May 2015 08:33:49 GMT

I have used the absolute path to locate the config file, but after having inserted another definition in the config file, i get null value when i try to get the NoOfRows('TAB1'); value.

What can i do to get the correct value?

Thanks

Marco

Re: Config file inclusion

Peter_Cammaert — Thu, 28 May 2015 07:40:27 GMT

Usually this means that the TAB1 table does not exist. Are you sure it is there when you call NoOfRows()? Use the Debug option in your script editor, or add Trace statements to get an idea of the path the execution engine follows in reality.

Best,

Peter

Re: Config file inclusion

marco_puccetti — Thu, 28 May 2015 08:01:17 GMT

I have tried also with the debug options and also i've declared the table inside the script, outside the config file, but it doesn't work yet.

Any ideas?

Marco

Re: Config file inclusion

Peter_Cammaert — Thu, 28 May 2015 08:09:32 GMT

Are you sure the table exists in your data model before you call NoOfRows()? Did you check the spelling of the table name?

Re: Config file inclusion

marco_puccetti — Thu, 28 May 2015 08:36:46 GMT

Yes i'm sure that there is the declaration of the table.

Marco

Re: Config file inclusion

Peter_Cammaert — Thu, 28 May 2015 08:42:40 GMT

How did you test this? Did you perform a STORE (just for fun) after the table was created? A declaration or a LOAD statement can still be duverted by QlikView deciding to concatenate the data to another table. Even when you specify a different name for the new table...

Peter

Re: Config file inclusion

Gabriel — Thu, 28 May 2015 08:51:14 GMT

Hi,

I suggested in the past (13-May-2015) that Marco should load the table in script first to ensure that the table is trying to use in the INCLUDE is free of error or any issue.

Marco, please load the your line of code in any qvw document or even the application where you're using the include statement and update the community of the result. Include NoConcatenate before the table

Best Regards,

Re: Config file inclusion

marco_puccetti — Thu, 28 May 2015 13:50:00 GMT

These is the code:

// Instagram parameters

InstagramSites:

LOAD * INLINE [

tpage, tSite

1111111111, Bancadinamica

];

This is the INLINE table loaded within the configuration file.

But when i'm going to retrive the NoOfRows it return NULL!

Marco

Re: Config file inclusion

Peter_Cammaert — Thu, 28 May 2015 14:33:02 GMT

Just FYI, after running

// Instagram parameters

InstagramSites:

LOAD * INLINE [

tpage, tSite

1111111111, Bancadinamica

];

LET vISRows = NoOfRows('InstagramSites');

the list in Settings->Variable OverView tells me that vISRows contains 1. It must be something else.

Peter

Re: Config file inclusion

marco_puccetti — Thu, 28 May 2015 14:39:15 GMT

I have made the same thing you said but it still gives me NULL return.

Marco

Re: Config file inclusion

Peter_Cammaert — Thu, 28 May 2015 14:54:53 GMT

Add the following statement immediately before the call to NoOfRows():

STORE InstagramSites INTO [.\InstagramSites] (qvd);

and run your script again. Do you get an error?

If not, then what other statements assign values to these variables? Do you clean up at the end of the script by setting all temporary variables to nothing?

Re: Config file inclusion

Gabriel — Thu, 28 May 2015 16:16:49 GMT

Hi,

I got 1 in the vISRows variable in UI.

What I can think of is in your Inline load ensure that there's no empty row before ];

If the Include is not working for you in your script, then have the table loaded directly in the script instead of using Include statement.