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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Comment out the part of script via sub routines

Hi Folks,

i have the following situation and i am using in my script- area: the incremental load. It does look like:

// main:

// LOAD

//     mit_id,

//     mit_name,

//     mit_gehalt,

//     mit_datum

// FROM [lib://Excel/Mitarbeiter.xlsx]

// (ooxml, embedded labels, table is Tabelle1);

// Store main into [lib://QVD/main.qvd];

temp_main:

load

    mit_id,

    mit_name,

    mit_gehalt,

    mit_datum

FROM [lib://QVD/main.qvd]

(qvd);

Max_Value:

load Max(mit_datum) as MaxWert

Resident temp_main;

let vNeu = peek('MaxWert',-1,'Max_Value');

drop Table temp_main;

main_neu:

LOAD

    mit_id,

    mit_name,

    mit_gehalt,

    mit_datum

FROM [lib://Excel/Mitarbeiter.xlsx]

(ooxml, embedded labels, table is Tabelle1) where mit_datum >= $(vNeu);

Concatenate

LOAD

    mit_id,

    mit_name,

    mit_gehalt,

    mit_datum

FROM [lib://QVD/main.qvd]

(qvd)where not Exists(mit_id);

Store main_neu into [lib://QVD/main.qvd];

As you see, i commented out the first part of script. My questions is:

Is there any possibilities or technique to comment out the first part of script via sub routines?

Thanks a lot

Beck

11 Replies
beck_bakytbek
Master
Master
Author

Omar thanks a lot for your help and time.

beck_bakytbek
Master
Master
Author

Hello Marcus,

thanks a lot for your help and time