Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
in a sql table I have the company name.
once read the sql table, I would like to stop the script if the value of the company name is different from the one put into a variable.
for example:
September vCompanyName = 'QlikView';
load CompanyName
SQL SELECT CompanyName,
FROM Table;
When exit Script ........... ??
how I should write instead of??.
thank you in antiipo.
hello
I assume your CompanyNameTable table contains only 1 record.
You can access a data model table record from within the script using Peek() function:
Let vLoadedCompanyName = Peek('CompanyName',-1,'CompanyNameTable');
I assume your CompanyNameTable table contains only 1 record.
You can access a data model table record from within the script using Peek() function:
Let vLoadedCompanyName = Peek('CompanyName',-1,'CompanyNameTable');
hello. Thank you. I've been a lot of help