Joining Data lineage QVX files

[#1]

Hi,

Our customer is running Governance Dashboard and they want us to show lineage in a custom java app. To accomplish that we are joining files in QVX_LastRun-folder through a custom QV app (see script below) and producing a csv-file.

I am not completely sure we are joining QVDFields.qvx, QVDTables.qvx and QVDLineage.qvx in a right way. Here is the script code:

tabQvdLineage:

LOAD

LoadDateKey,

QVDFieldName

FROM
(qvx);

INNER JOIN LOAD

LoadDateKey,

TableName

FROM
(qvx);

INNER JOIN LOAD

LoadDateKey,

Process as QVDProc,

Target,

Source,

LoadStatement

FROM
(qvx);

Kind regards

A.H.

[Qrishna]

Hi,

Try Left Join instead of Inner Join, by doing the inner join you may lose the data from tabQvdLineage as inner join

returns the common data values between two tables where as left join keeps the tabQvdLineage as is and new columns will be added based on the field value from tabQvdLineage.

[Qrishna]

The Below Picture gives you a perfect example for each join in qlikview.

[#4]

Thx for the answer but the question was if those three QVXs should be joined in order to give relation QVD table->QVD fields.

[Qrishna]

Answer is No.

There is a common key LoadDateKey in all the tables hence when you load them, Qlikview will automatically associate all the loaded tables based on the common key field.

You can relate/associate the tables just by loadin the tables, as they have a common key.

If you want to make all the table into one single table then

T1:

LOAD * inline [

LoadDateKey, QVDFieldName

];

inner Join

LOAD * inline [

LoadDateKey,TableName

];

inner Join

LOAD * inline [

LoadDateKey,QVDProc, Target,Source, LoadStatement

];

gives you

[#6]

Sry but I think you missunderstood my question completly.

I asked if querying QVDFields.qvx, QVDTables.qvx and QVDLineage.qvx found inside of QVX_LastRun-folder may give answer to QVD tables and their related fields.

[#7]

Sry but I think you missunderstood my question completly.

I asked if querying QVDFields.qvx, QVDTables.qvx and QVDLineage.qvx found inside of QVX_LastRun-folder may give answer to QVD tables and their related fields.