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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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
MVP
MVP

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