Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Omar thanks a lot for your help and time.
Hello Marcus,
thanks a lot for your help and time