Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Are you sure the table exists in your data model before you call NoOfRows()? Did you check the spelling of the table name?
Yes i'm sure that there is the declaration of the table.
Marco
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
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,
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
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
I have made the same thing you said but it still gives me NULL return.
Marco
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?
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.