Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We currently create an inline table to manually list the input files (generally QVDs or excel files) and output files (QVDs, Data Models) that a document consumes and produces. Because that's manually generated, it quite often gets out of date.
Is there a function that will run through our script and gather all of the inputs (From...) and outputs (Store ... Into...) so we can use them to auto populate this type of documentation model?
Brett, closing the loop on this.
I did a binary load of the governance dashboard and put the Lineage table into a QVD. Then loaded source and target from that QVD into each qvw, where DocName = DocumentName().
Works like a charm.
If the folder struct is relatively static as in your example:
for each File in filelist('Shared\10_Data\Raw\*')
DataSource:
load 'Input' as Direction,
'Shared\10_Data\Raw' as Source,
Replace('$(File)','Shared\10_Data\Raw\','') as FileorDatabaseName
autogenerate 1;
next File
for each File in filelist('Shared\10_Data\Staged\*')
Concatenate
DataSource:
load 'Input' as Direction,
'Shared\10_Data\Staged' as Source,
Replace('$(File)','Shared\10_Data\Staged\','') as FileorDatabaseName
autogenerate 1;
next File
for each File in filelist('Shared\10_DataModel\*')
Concatenate
DataSource:
load 'Input' as Direction,
'Shared\10_DataModel' as Source,
Replace('$(File)','Shared\10_DataModel\','') as FileorDatabaseName
autogenerate 1;
next File
I would suggest looking at the Governance Dashboard:
https://help.qlik.com/en-US/governance-dashboard/Content/QV_GovDashboard/Lineage.htm
There is a link in another section of the Help for it to the place to download the application, just FYI.
Regards,
Brett
Brett, closing the loop on this.
I did a binary load of the governance dashboard and put the Lineage table into a QVD. Then loaded source and target from that QVD into each qvw, where DocName = DocumentName().
Works like a charm.