Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

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 ?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
6 Replies
marcus_sommer

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

- Marcus

micheledenardi
Specialist II
Specialist II
Author

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
micheledenardi
Specialist II
Specialist II
Author

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
marcus_sommer

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
Specialist II
Specialist II
Author

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
marcus_sommer

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