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
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
This is extracting the file. no real reason to use load statement if no transformation is taking place.
; This SQL Select Statement is pulling from a database via ODBD connection listed above.
SQL SELECT *
//SQL SELECT *
//FROM TESTAPP.QLIKBACKUP.DLYSHPPF; //backup
This is storing the qvd file.
store ShipDaily_Raw into DataSources\ShipDaily_Raw_$(FileDate).qvd;