topic Re: ETL inside loadscript - Conditional load based on a variable? in QlikView

ETL inside loadscript - Conditional load based on a variable?

Mon, 21 Oct 2013 15:56:56 GMT

I have 5 huge delimited text files containing data that need transformations. For development purposes, I want to do the following:

LET vToggleETL = 1;

if vToggleETL = 1 {
     // load text files and develop data model, do any transformation as necessary
     // store tables into QVD's
}
else {
     // LOAD data model from qvd's
}

I'd like to toggle vToggleETL from time to time. Also, the client has said the input files will remain the same month to month. So for data refreshes, I'll just toggle vToggleETL.

Questions: 1) Is this the best approach? 2) Is this the correct syntax?

Re: ETL inside loadscript - Conditional load based on a variable?

Gysbert_Wassenaar — Mon, 21 Oct 2013 16:52:30 GMT

1. Sounds sensible. What you can do is set the variable at the end of the script instead and give it the value 0. You can pass a variable name + value as parameter if you want to reload it: qv.exe /r /vvToggleETL=1 "d:\qvapps\myqvwapp.qvw". The double v is intended. /v for passing a variable followed by the variable name

2. See below:

if $(vToggleETL) = 1 then

// load text files and develop data model, do any transformation as necessary

// store tables into QVD's

else

// LOAD data model from qvd's

end if

LET vToggleETL = 0;