Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Joining Data lineage QVX files

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.

6 Replies
krishna_2644
Valued Contributor III

Re: Joining Data lineage QVX files

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.


all-joins.png

krishna_2644
Valued Contributor III

Re: Joining Data lineage QVX files

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

Qlikview joins.png

Not applicable

Re: Joining Data lineage QVX files

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

krishna_2644
Valued Contributor III

Re: Joining Data lineage QVX files

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.

Capture1.PNG

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

Capture2.PNG

Not applicable

Re: Joining Data lineage QVX files

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.

Not applicable

Re: Joining Data lineage QVX files

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.

Community Browser