Sample script for Utilisation of Qlik Sense Engine "Allow data lineage"
Article Number: 000055616 | Last Modified: 2018/11/21
Qlik Sense Engine has an option that is on by default to store the lineage information around a QVD within the header of the QVD. Configuration and explanation of the feature can be found here: https://help.qlik.com/sense/Subsystems/ManagementConsole/Content/engines-overview.htm
This article provide the sample script (from R&D) to trace the lineage of the data right through the data manipulation layers within Qlik Sense.
If there is a set up of deployment in the Qlik server to adapt the provided script snippet (For example the qvd's needs to be available for the the app loading the meta data.)
It is ok to load the data into Qlik Sense App.
Sxample script below:
for each vFile in FileList('lib://MyFolderConenction/*.qvd')
let vFileName = mid(vFile, index(vFile, '\', -1) + 1, 99);
1 as FieldCount,
'$(vFileName)' as [File Name],
FieldName as [Field Name],
BitOffset as [Bit Offset],
BitWidth as [Bit Width],
Bias as [Bias],
NoOfSymbols as [No Of Symbols],
[NumberFormat/Type] as Type,
[NumberFormat/nDec] as Dec,
[NumberFormat/UseThou] as UseThou
FROM [$(vFile)] (XmlSimple, Table is [QvdTableHeader/Fields/QvdFieldHeader]);