topic Reload Metadata Only in QlikView

Reload Metadata Only

Mon, 27 Oct 2014 15:24:47 GMT

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.

Re: Reload Metadata Only

alexandros17 — Mon, 27 Oct 2014 15:32:30 GMT

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

Re: Reload Metadata Only

markodonovan — Mon, 27 Oct 2014 15:35:27 GMT

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

Re: Reload Metadata Only

markodonovan — Mon, 27 Oct 2014 15:41:48 GMT

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

Re: Reload Metadata Only

Anonymous — Mon, 27 Oct 2014 20:43:18 GMT

In the QlikView Desktop Script Editor :

Click <Debug>
Tick <Limited Load>
Default is to only load 10 rows in each load statement

Re: Reload Metadata Only

Mon, 15 Dec 2014 16:48:36 GMT

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.