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: 
JACKNIEKERK
Creator
Creator

Some way to skip part of load script during load

During testing i want to skip some load calls in loadscript

i do now , wich works , but not handy due to editting to activate or not-activate

by placing this at front   //rem  

is there a way to have a goto or dummy statement before first line where i want to quit loading

e.e. something like

 

Goto FromHereOk

then under last remmed the label?

 

load
Groepnr as Hoofdgroep15 ,
SubGroepnr as SubGroepnr15 ,
Text1 as Omschrijving15 ,
Volgorde as Volgorde15 ,
Aanuit as AanUit15;
//rem SQL SELECT * from HOOFDGROEPEN;

load
Groepnr as Hoofdgroep16 ,
SubGroepnr as SubGroepnr16 ,
Text1 as Omschrijving16 ,
Volgorde as Volgorde16 ,
Aanuit as AanUit16;
//rem SQL SELECT * from HOOFDGROEPEN;

load
Groepnr as Hoofdgroep17 ,
SubGroepnr as SubGroepnr17 ,
Text1 as Omschrijving17 ,
Volgorde as Volgorde17 ,
Aanuit as AanUit17;
//rem SQL SELECT * from HOOFDGROEPEN;

load
Groepnr as Hoofdgroep18 ,
SubGroepnr as SubGroepnr18 ,
Text1 as Omschrijving18 ,
Volgorde as Volgorde18 ,
Aanuit as AanUit18;
//rem SQL SELECT * from HOOFDGROEPEN;

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@JACKNIEKERK 

Have you tried using Sub ...end sub , then apply the subroutine  according to a variable .

or Switch..case..default..end switch, like this example from help :

Switch I

Case 1

LOAD '$(I): CASE 1' as case autogenerate 1;

Case 2

LOAD '$(I): CASE 2' as case autogenerate 1;

Default

LOAD '$(I): DEFAULT' as case autogenerate 1;

End Switch

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@JACKNIEKERK 

Have you tried using Sub ...end sub , then apply the subroutine  according to a variable .

or Switch..case..default..end switch, like this example from help :

Switch I

Case 1

LOAD '$(I): CASE 1' as case autogenerate 1;

Case 2

LOAD '$(I): CASE 2' as case autogenerate 1;

Default

LOAD '$(I): DEFAULT' as case autogenerate 1;

End Switch

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
JACKNIEKERK
Creator
Creator
Author

True, i did place all not wanted in the case i  (then is dummy value)   loop

all between start and and case are the line now remmed , they can stay on due to being ignored in the case loop

Thanks for advice

Regards Jack