Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

QDF / Store $(vL.TableName) into... not recognized "unknown statement"

hi community

I am using for first time the QDF. In the tranform Container, under Application i am loading tables from the extract Container and storing them as QVDs, according to the QDF, ie. using the Standard variables

ll tables load well except for a table, which is not recognized. any idea why is this Happening? thanks!

recognized.  .  QDF_StoreVar.pngScriptError.png

//the Script Structure is like this:

// ----------------------------------------
// Load TABLE QVD
// ----------------------------------------

LET vL.TableName='table';
LET vL.before=now();


table_tmp:
LOAD field1,
field2,
...............
  fieldn   
FROM $(vG.Folder_ExtractQVDPath)v_table.qvd(qvd);

Concatenate(table_tmp)
LOAD field11,
field21,
.............
fieldn1
FROM $(vG.Folder_ExtractQVDPath)v_table1.qvd(utf8,qvd);

NoConcatenate
[$(vL.TableName)]:
LOAD field1,
    field2,
  field11,
..........
fieldn
Resident table_tmp;

drop table table_tmp;

// ----------------------------------------
// Write out the QVD to the defined path
// ----------------------------------------

STORE $(vL.TableName) INTO $(vL.QVDPath)\$(vL.TableName).qvd;                                                                                                                                                                                 

// ----------------------------------------
// Create statistical data
// ----------------------------------------
LET vL.after=now();
LET vL.TableNumber=$(vL.TableNumber)+1;
let vL.TableName_$(vL.TableNumber) ='$(vL.TableName)';
let vL.NoOfRows_$(vL.TableNumber) = NoOfRows('$(vL.TableName)');
let vL.NoOfFields_$(vL.TableNumber) = NoOfFields('$(vL.TableName)');
let vL.TableTime_$(vL.TableNumber) =time(Timestamp('$(vL.after)') - timestamp('$(vL.before)'),'hh:mm:ss');

// *****************************************;
// Drop table;
//*****************************************;
DROP Table $(vL.TableName);

trace 'Dropped Table $(vL.TableName)';

4 Replies
lucianoginqo
Partner - Contributor III
Partner - Contributor III

Hi Felipe, are you sure you don't have the STORE $(vL.TableName) commented out?

Looks to me that it's like the statement starts from the INTO, not the STORE statement



felcar2013
Partner - Creator III
Partner - Creator III
Author

hi Luciano

i had two of them, an did not see it, thanks!

maximiliano_vel
Partner - Creator III
Partner - Creator III

Perhaps if you use

STORE [$(vL.TableName)] into [$(vL.QVDPath)\$(vL.TableName).qvd];

Notice the brackets

felcar2013
Partner - Creator III
Partner - Creator III
Author

Hola Maximiliana

ya funciona, gracias, era una parte del codigo que estuvo mal y efectivamente QV no leyo todo

fue mas un problema de sintaxis

felipe