Qlikview function for input and output documentation

[mcowley1]

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?

[jwjackso]

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

[Brett_Bleess]

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

[mcowley1 · Accepted solution]

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.