Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
When I open the qvw that has the script to generate qvd (developed by other developer), how would I know what tables and what database (whether the data used is a flat file, or sql server table or, AS400, or...). Please check and advise/explain on the syntax I see when I open the qvw. Thanks Much
// CONNECT32 TO qlik2 (UserID="Userid" Password="Password");
LET
FileDate = = date(today()-1,'YYYYMMDD');
ShipDaily_Raw:
LOAD
*
;
SQL SELECT *
FROM TESTAPP.QLIKFILES.DLYSHPPF;
//SQL SELECT *
//FROM TESTAPP.QLIKBACKUP.DLYSHPPF; //backup
store ShipDaily_Raw into DataSources\ShipDaily_Raw_$(FileDate).qvd;
//ODBC
I don't think qvd's have the data you are looking for but if you want to pull the xml headers you can get the table information and field information by telling the table file wizard that the file is an xml file. You'll end up with some code that will look something like the following.
There is lots of useful table information but the source code used to create it would be found in the original qvw
// Start of [Fruit.qvd] LOAD statements
QvdFieldHeader:
LOAD FieldName,
BitOffset,
BitWidth,
Bias,
NoOfSymbols,
Offset,
Length,
[NumberFormat/Type] as Type,
[NumberFormat/nDec] as nDec,
[NumberFormat/UseThou] as UseThou,
%Key_QvdTableHeader_B94FCCAC68ED3E20 // Key to parent table: QvdTableHeader
FROM Fruit.qvd (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);
QvdTableHeader:
LOAD QvBuildNo,
CreateUtcTime,
SourceFileSize,
TableName,
RecordByteSize,
NoOfRecords,
Offset,
Length,
%Key_QvdTableHeader_B94FCCAC68ED3E20 // Key for this table: QvdTableHeader
FROM Fruit.qvd (XmlSimple, Table is [QvdTableHeader]);
// End of [Fruit.qvd] LOAD statements
To create a QVD file you use the store command.
test:
Select * from mydatabase;
store * from test into test.qvd; //This creates the qvd file.
The data lineage is not stored in the QVD. That information can be captured via metadata however.
Thanks. Please check the syntax i got from the qvw and advise on the same
Thanks. Please check the syntax i got from the qvw and advise on the same
Did you edit your original post? I'm totally confused because there is stuff there that I did not see originally. Oh Well
There is nothing happening in this script
Pulling all rows and fields from TESTAPP.QLIKFILES.DLYSHPP and sending that table into a qvw
the file date ends up being yesterday but it is not used anywhere.
// CONNECT32 TO qlik2 (UserID="Userid" Password="Password");
Line above forces connection to a 32 bit dirver
This created a date value
LET FileDate = = date(today()-1,'YYYYMMDD');
This names the table
ShipDaily_Raw:
This is extracting the file. no real reason to use load statement if no transformation is taking place.
LOAD
*
; This SQL Select Statement is pulling from a database via ODBD connection listed above.
SQL SELECT *
FROM TESTAPP.QLIKFILES.DLYSHPPF;
//SQL SELECT *
//FROM TESTAPP.QLIKBACKUP.DLYSHPPF; //backup
This is storing the qvd file.
store ShipDaily_Raw into DataSources\ShipDaily_Raw_$(FileDate).qvd;
//ODBC
Thanks Much for being so clear. Is it possible to know what kind of databse, whether the table is from a SQL database or, AS400, or Oracle Database, etc?
Thanks Much for being so clear. Is it possible to know what kind of databse, whether the table is from a SQL database or, AS400, or Oracle Database, etc?
Yes. I did edit the post, since I felt I wasn't clear and the script would help. Thanks for replying.
Is it possible to know what kind of databse, whether the table used is from a SQL database or, AS400, or Oracle Database, etc?