topic Re: Remove Metadata Before Store QVDs in Connectivity & Data Prep

Remove Metadata Before Store QVDs

micheledenardi — Fri, 02 Apr 2021 07:57:46 GMT

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.

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 ?

Re: Remove Metadata Before Store QVDs

marcus_sommer — Wed, 05 Jul 2017 11:24:27 GMT

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

- Marcus

Re: Remove Metadata Before Store QVDs

micheledenardi — Wed, 05 Jul 2017 11:34:31 GMT

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

Re: Remove Metadata Before Store QVDs

micheledenardi — Wed, 05 Jul 2017 11:44:39 GMT

I've found this property on QlikSense QMC.

Advanced ‒ Qlik Sense‌

It's exactly what i need.

Re: Remove Metadata Before Store QVDs

marcus_sommer — Wed, 05 Jul 2017 11:44:42 GMT

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

- Marcus

Re: Remove Metadata Before Store QVDs

micheledenardi — Wed, 05 Jul 2017 12:06:17 GMT

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

Re: Remove Metadata Before Store QVDs

marcus_sommer — Wed, 05 Jul 2017 12:29:56 GMT

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