6 Replies Latest reply: May 27, 2015 2:49 PM by Omar Slomic RSS

    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 [C:\Users\Dev\Desktop\QlikView\QVX&QVD\QVX_LastRun\QVDFields.qvx]
      (
      qvx);

      INNER JOIN LOAD

      LoadDateKey,

      TableName

      FROM [C:\Users\Dev\Desktop\QlikView\QVX&QVD\QVX_LastRun\QVDTables.qvx]
      (
      qvx);

      INNER JOIN LOAD

      LoadDateKey,

      Process as QVDProc,

      Target,

      Source,

      LoadStatement

      FROM [C:\Users\Dev\Desktop\QlikView\QVX&QVD\QVX_LastRun\QVDLineage.qvx]
      (
      qvx);

       

       

      Kind regards

      A.H.