Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Dependency Matrix

cancel
Showing results for 
Search instead for 
Did you mean: 
felipedl
Partner
Partner

Dependency Matrix

Attachments

Hi Qlikers,

Update:

  • Added a date formatting parameter to verify if the QVDs are in a certain format to the QVW.
  • Added the QVW lineageinfo directly by loading the Discriminator field from the [DocumentSummary/LineageInfo] of the QVW information (as pointed out by fosuzuki‌).

By adding the format, the code will check the QVD's name for the formatting specified in the field bellow:

sample.png

As an example, the marked QVDs in the following picture:

sample.png

Will be shown as on the matrix:

- Another_Test_*.qvd

- Test_QVD_*.qvd

- Yet_Another_Test_*.qvd

Simple explanation on the input fields:

- QVDs Path: paths, that can be separated by semicolon, where the DoDir function will look up for the QVD files used for creating the matrix.

- QVWs Path: paths, that can be separated by semicolon, where the DoDir function will look up for the QVW files used for creating the matrix.

- QVD Date Mask Format: date formatting, like MM_DD_YYYY to check which QVD files have similar formatting. Due to the string comparison, it's better to have the lengthiest date formats to the left and single modifiers should be to the right. Must be separated by semicolon.


Example:

If QVD has YYYY_MM, YY_MM, MM_YYYY and MM_YY the input string for the date format should be like:

'YYYY_MM;YY_MM;MM_YYYY;MM_YY'.

That is needed because if the order was reversed, let's say by having the following: 'YYYY_MM;YY_MM;MM_YY;MM_YYYY', it would avail that the string 'Final_Test_02_2018' be computed as 'MM_YY' and not 'MM_YYYY' because of the '02_20' string being a valid Month / Year.

The paths must contain the type of file to be read, the sample paths used in my example for QVDs are as follow:

- "QVD-Extract\*.qvd;QVD-Transform\*.qvd"

After setting up the parameters, just reload the app to view the matrix, being classified as:

- W: File being written (QVD)

- R: File being read (QVD)

- R / W: QVW that both writes and reads a QVD.

Attached is a new sample structure with the QVDs having date formats for the Dependency Matrix app.

Hope you guys can take a look at it and point out some improvements.

Felipe!

Comments
vinafidalgo
Partner
Partner

Very nice, thank you!

bcavestro
Creator
Creator

Great! Pretty usefull!

Version history
Last update:
‎2018-04-23 09:19 AM
Updated by: