Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
micheledenardi
Valued Contributor

Remove Metadata Before Store QVDs

Hi experts,

i'm using the REST connector to retrieve some statistics from the web and store them into QVDs.

Loading these QVDs as XML file i've seen they contains a table named LineageInfo (Load * FROM [MyQvd.qvd] (XmlSimple, Table is [QvdTableHeader/Lineage/LineageInfo])) which is populated with lot of metadata info (generated by the REST connector.) that i don't care to keep.

2017-07-05 11_51_21-QlikView x64 Personal Edition - [C__Users_Michele.Denardi_Desktop_aaa.qvw_].png

The only way i've found to "clean" my QVDs from these information is to re-load them after the download procedure and overwrite the existing QVDs (doing this the LineageInfo table is dropped and the QVD size is drastically reduced, from 3Mb to 10Kb).

This way to drop metadata info is very impratical and i would like to know if there is a best way to remove this information before doing the QVD Store. Something like "Drop Metadata" statement.

I've already tried to make a resident load of the data (before storing the qvd and specifying each field) but the metadata information are maintained

Anybody can help me on this ?

6 Replies
MVP & Luminary
MVP & Luminary

Re: Remove Metadata Before Store QVDs

Maybe you could find such a (hidden) setting within the easter egg:

- Marcus

micheledenardi
Valued Contributor

Re: Remove Metadata Before Store QVDs

Hi Marcus,

does this flag exists on QlikSense ?

Because i'm using qlikview only for some data quality check... my production environment is on QlikSense

micheledenardi
Valued Contributor

Re: Remove Metadata Before Store QVDs

I've found this property on QlikSense QMC.

Advanced ‒ Qlik Sense

It's exactly what i need.

2017-07-05 13_41_38-Edit engine - QMC.png

MVP & Luminary
MVP & Luminary

Re: Remove Metadata Before Store QVDs

This setting exists within qlik sense. Take a look on this discussion: Re: Allow data lineage. Please explain the value of this parameter.

- Marcus

micheledenardi
Valued Contributor

Re: Remove Metadata Before Store QVDs

Unfortunately, i'm in the same situation of  Goran and i want to turn off lineage app-by-app and not on entire environment....

2017-07-05 14_05_05-Allow data lineage. Please explain the value of... _ Qlik Community.png

MVP & Luminary
MVP & Luminary

Re: Remove Metadata Before Store QVDs

I have assumed it. Maybe there is a future adjustment to this setting but I think at the moment you will further need your workaround.

- Marcus