How to terminate the execution of a script?

[#1]

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?

[sasiparupudi1]

exit script when a=1

or

if(1=1) then

EXIT Script;

end if;

hth

Sasi

[engishfaque]

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

[Karim_Khan]

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