Hi Experts,
We recently upgraded from 12.10 to 12.40 version of QlikView.
Below is the code that works fine in 12.10 but not in 12.40. It throws unknown statement error.
Your help here is highly appreciated.
Attached are the error messages that I receive and the actual qvc.qvs file that I use while generating the QVD's using the qvdGenerator.qvw. This generator uses an excel file to get the list of tables names and the load code.
//==========================================================//==========================================================// Execute the SQL Select.//==========================================================
[$(Qvc.Loader.v.Tablename)]: // vTablename is set by the IncrementalSetup routine.
Rem; // Fix syntax error from table label with variable // If LOAD Statement provided, use it
IF len('$(_qvctemp.den.loadStatement)')>0 THEN
$(_qvctemp.den.loadStatement);
ELSE // No LOAD Statement, build a SQL SELECT
IF $(Qvc.Loader.v.CreateExtractTimestampField) THEN
LOAD *, now(1) as ExtractTimestamp;
ENDIF
SQL SELECT $(_qvctemp.den.columns) FROM $(_qvctemp.den.table) WHERE $(Qvc.Loader.v.IncrementalExpression) //incrementalExpression is set up the Qvc.IncrementalSetup routine. ;
ENDIF
Qvc.zip
Hi Experts,
We recently upgraded from 12.10 to 12.40 version of QlikView.
Below is the code that works fine in 12.10 but not in 12.40. It throws unknown statement error.
Your help here is highly appreciated.
Attached are the error messages that I receive and the actual qvc.qvs file that I use while generating the QVD's using the qvdGenerator.qvw. This generator uses an excel file to get the list of tables names and the load code.
//==========================================================//==========================================================// Execute the SQL Select.//==========================================================
[$(Qvc.Loader.v.Tablename)]: // vTablename is set by the IncrementalSetup routine.
Rem; // Fix syntax error from table label with variable // If LOAD Statement provided, use it
IF len('$(_qvctemp.den.loadStatement)')>0 THEN
ELSE // No LOAD Statement, build a SQL SELECT
ENDIF
Qvc.zip