Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Use
Exit Script;
rest of the scrip is on different tabs
exit is not working with if condition
I think that should not be a problem
can you please share your script
It should work but try before without condition.
hi,
if you want to load only certain tables and still have other tables in memory.
maybe use partial reload option
By using Exit script function we can terminate the script