topic Re: Qlikview function for input and output documentation in QlikView

Qlikview function for input and output documentation

mcowley1 — Sat, 16 Nov 2024 18:34:35 GMT

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?

Re: Qlikview function for input and output documentation

jwjackso — Thu, 28 May 2020 20:02:36 GMT

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

Re: Qlikview function for input and output documentation

Brett_Bleess — Tue, 16 Jun 2020 20:11:43 GMT

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

Re: Qlikview function for input and output documentation

mcowley1 — Thu, 27 Aug 2020 17:49:59 GMT

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.