Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
francofiorillo
Partner - Creator
Partner - Creator

exit script

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

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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');

View solution in original post

2 Replies
swuehl
Champion III
Champion III

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');

francofiorillo
Partner - Creator
Partner - Creator
Author

hello. Thank you. I've been a lot of help