Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)';
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
hi Luciano
i had two of them, an did not see it, thanks!
Perhaps if you use
STORE [$(vL.TableName)] into [$(vL.QVDPath)\$(vL.TableName).qvd];
Notice the brackets
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