Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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