topic Re: QDF / Store $(vL.TableName) into... not recognized "unknown statement" in Archived Groups

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

felcar2013 — Tue, 22 Jul 2025 17:59:49 GMT

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. .

//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)';

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

lucianoginqo — Mon, 12 Jan 2015 11:04:45 GMT

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

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

felcar2013 — Mon, 12 Jan 2015 11:44:47 GMT

hi Luciano

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

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

maximiliano_vel — Sat, 17 Jan 2015 16:09:26 GMT

Perhaps if you use

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

Notice the brackets

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

felcar2013 — Mon, 19 Jan 2015 09:38:36 GMT

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