topic Re: How to terminate the execution of a script? in QlikView

How to terminate the execution of a script?

Mon, 14 Sep 2015 09:26:53 GMT

How to terminate the execution of a script using a condition?

Edit:

LOAD Date(Date#([dtmAddedOn],'YYYY-MM-DD'),'DD/MM/YYYY') as dtmAddedOn,
Num(dtmAddedOn) as ndtmAddedOn,
Num(today()) as today;
SQL SELECT CAST(dtmAddedOn As DATE) as dtmAddedOn
FROM SalesTable;

IF (ndtmAddedOn < Num(today())) then
EXIT Script;

rest of the script in multiple tabs
ENDIF; //(in last tab)

It's not working....why?

Re: How to terminate the execution of a script?

avinashelite — Mon, 14 Sep 2015 09:28:13 GMT

try like this

if condition Then

Exit script

else

rest of the script

end if

format:

if condition then

[ statements ]

{ elseif condition then

[ statements ] }

[ else

[ statements ] ]

end if

Re: How to terminate the execution of a script?

alexandros17 — Mon, 14 Sep 2015 09:29:18 GMT

Use

Exit Script;

Re: How to terminate the execution of a script?

Mon, 14 Sep 2015 09:29:47 GMT

rest of the scrip is on different tabs

Re: How to terminate the execution of a script?

Mon, 14 Sep 2015 09:30:34 GMT

exit is not working with if condition

Re: How to terminate the execution of a script?

avinashelite — Mon, 14 Sep 2015 09:34:20 GMT

I think that should not be a problem

Re: How to terminate the execution of a script?

avinashelite — Mon, 14 Sep 2015 09:34:52 GMT

can you please share your script

Re: How to terminate the execution of a script?

alexandros17 — Mon, 14 Sep 2015 09:40:31 GMT

It should work but try before without condition.

Re: How to terminate the execution of a script?

Anonymous — Mon, 14 Sep 2015 09:48:51 GMT

hi,

if you want to load only certain tables and still have other tables in memory.

maybe use partial reload option

Re: How to terminate the execution of a script?

Mon, 14 Sep 2015 09:59:31 GMT

By using Exit script function we can terminate the script

Re: How to terminate the execution of a script?

sasiparupudi1 — Mon, 14 Sep 2015 10:19:11 GMT

exit script when a=1

if(1=1) then

EXIT Script;

end if;

hth

Sasi

Re: How to terminate the execution of a script?

engishfaque — Mon, 14 Sep 2015 10:50:33 GMT

Dear Yvishal153,

Use EXIT Script, such as shown in listed below example:

Load * from file.xlsx;

Load * from file2.xlsx;

EXIT Script;

Load * from file3.xlsx;

Kind regards,

Ishfaque Ahmed

Re: How to terminate the execution of a script?

Karim_Khan — Mon, 21 Dec 2015 10:48:42 GMT

Hi Avinash,

I am also facing the issue of script execution window is getting stuck after fetching the records through reload/debugger limited rows.

My Script is as below

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:redshift://ucpprd.cusjr55gdzdb.us-east-1.redshift.amazonaws.com:5439/ucpprd?ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory;XUserId=CTCZMadLULaOXQVNNF;XPassword=RBfVGadLULaOXQVNDJQIWZNJRRMGDUC;";

T_WAR_PRODUCT:

//First 100

LOAD *;

SQL SELECT *

FROM ucpprd.ucp."t_war_product";

//STORE T_WAR_PRODUCT INTO D:\UCP\T_PRODUCT.qvd (qvd);

and PFB GenrateFile Logs Data

12/21/2015 4:00:36 PM: Execution started.

12/21/2015 4:00:36 PM: QlikView Version:11.00.11154.0

12/21/2015 4:00:36 PM: CPU Target x64

12/21/2015 4:00:36 PM: Operating System Windows 7 Professional Service Pack 1 (64 bit edition)

12/21/2015 4:00:36 PM: Wow64 mode Not using Wow64

12/21/2015 4:00:36 PM: MDAC Version 6.1.7601.17514

12/21/2015 4:00:36 PM: MDAC Full Install Version 6.1.7601.17514

12/21/2015 4:00:36 PM: PreferredCompression 2

12/21/2015 4:00:36 PM: EnableParallelReload 1

12/21/2015 4:00:36 PM: ParallelizeQvdLoads 1

12/21/2015 4:00:36 PM: AutoSaveAfterReload 0

12/21/2015 4:00:36 PM: BackupBeforeReload 1

12/21/2015 4:00:36 PM: EnableFlushLog 0

12/21/2015 4:00:36 PM: SaveInfoWhenSavingFile 0

12/21/2015 4:00:36 PM: UserLogfileCharset 0

12/21/2015 4:00:36 PM: OdbcLoginTimeout -1

12/21/2015 4:00:36 PM: OdbcConnectionTimeout -1

12/21/2015 4:00:36 PM: ScriptWantsDbWrite false

12/21/2015 4:00:36 PM: ScriptWantsExe false

12/21/2015 4:00:36 PM: LogFile CodePage Used: 1252

12/21/2015 4:00:40 PM: 0002 SET ThousandSep=','

12/21/2015 4:00:41 PM: 0003 SET DecimalSep='.'

12/21/2015 4:00:41 PM: 0004 SET MoneyThousandSep=','

12/21/2015 4:00:42 PM: 0005 SET MoneyDecimalSep='.'

12/21/2015 4:00:42 PM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

12/21/2015 4:00:43 PM: 0007 SET TimeFormat='h:mm:ss TT'

12/21/2015 4:00:44 PM: 0008 SET DateFormat='M/D/YYYY'

12/21/2015 4:00:44 PM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

12/21/2015 4:00:45 PM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

12/21/2015 4:00:45 PM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

12/21/2015 4:00:46 PM: 0017 CUSTOM CONNECT*Provider*JDBCConnector_x64.dll*XUserId*XPassword*

12/21/2015 4:00:51 PM: 0018 T_WAR_PRODUCT:

12/21/2015 4:00:51 PM: 0019

12/21/2015 4:00:51 PM: 0020

12/21/2015 4:00:51 PM: 0021 LOAD *

12/21/2015 4:00:52 PM: 0022 SQL SELECT *

12/21/2015 4:00:52 PM: 0023 FROM ucpprd.ucp."t_war_product"

12/21/2015 4:00:54 PM: 16 fields found: visit_dt, visitor_id, visit_nbr, ip_addr, hit_seq_nbr, hit_ts, site_nm, site_section_nm, product_nm, page_nm, product_view_cnt, product_edu_view_cnt, trial_initiate_cnt, cloud_initiate_cnt, edu_download_start_cnt, dt,

Regards,

Karim Khan