Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I 'reload' a dashboard, is there a way to do that and see updated metadata from the database without actually loading all of the data?
The dashboard I need to look at contains millions of rows of data, and takes a long time, and a lot of space to download. All I need to see is the metadata.
Thanks.
You should reduce loading setting conditions on your source tables,
when I develop documents with large amounts of data I use qvd where only last weeks or few customers are loaded, try somethig like this
Hi Chris,
You could try doing a partial reload.
Set the reload task to partial
In the loadscript use the IsPartialReload( ) function to run load to only read the metadata.
Thanks
Mark
www.techstuffy.com
Forgot to mention you also have to preced the load statment with an ADD\REPLACE.
For example:
Tab1:
LOAD Name, Number FROM Persons.csv;
ADD LOAD Name, Number FROM newPersons.csv;
Thanks
Mark
In the QlikView Desktop Script Editor :
You can always load the QVDs as xmls:
QvdFieldHeader:
LOAD FieldName,
BitOffset,
BitWidth,
Bias,
NoOfSymbols,
[NumberFormat/Type] as Type,
[NumberFormat/nDec] as nDec,
[NumberFormat/UseThou] as UseThou,
[NumberFormat/Dec] as Dec,
[NumberFormat/Thou] as Thou,
%Key_QvdTableHeader_B94FCCAC68ED3E20 // Key to parent table: QvdTableHeader
FROM $(vG.QVDPath)*.qvd (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);
QvdTableHeader:
LOAD QvBuildNo,
CreatorDoc,
CreateUtcTime,
SourceFileSize,
upper(TableName) as TableNameQVD,
RecordByteSize,
NoOfRecords,
%Key_QvdTableHeader_B94FCCAC68ED3E20 // Key for this table: QvdTableHeader
FROM $(vG.QVDPath)*.qvd (XmlSimple, Table is [QvdTableHeader]);
Also, you can store the system fields of a qvw files into a QVD os a csv file to see what has changed.