QVD Analyser: Automatically gather information on all QVDs under a root-drive or -folder (QVW)

    Hi everyone,

     

    Please find attached a script that will loop through all folders and sub-folders (you can even point to a specific drive) which will loop through and file all information relating to the underlying QVDs, including table name, records/number of rows, fields, as well as a front-end cross table to see the foreign key relationship (field names shared) across QVDs.

     

    All you need to do is change the variable value (input box or script) and point to a root drive or folder. It will automatically read all QVDs in the given folder and sub-folders. You can also use this file for Sense. Please look at the script and the sample variable input for a Sense "LIB" connection/folder.

     

    Hope you find it useful.


    Please check note below on what "v2" contains (QlikView for QlikSense Task analysis).

    For QVF Version for QlikSense Server, please look here: QlikSense Tasks Gantt Waterfall Chart & Analyse Corresponding QVDs

     

    NOTE:

    I feel a tad embarrassed. If you are on QlikView, use the Governance Dashboard.

    Create a horizontal bar chart with:

    Dim: TaskResult_Name

    Expr: "MaxString(NUM(FinishedAt)) - MaxString(NUM(StartedAt))"

              with offset "FRAC(MaxString(StartedAt))"

    Sort by: Expr = "MaxString(StartedAt)".

    You should be able to obtain a Gantt chart of all your reloads with all the extra goodies in Gov Dashboard.

    ____________

     

    Kr,

     

    Cheenu


    Special thanks to Henrik Cronstrom: @loop through to load all files from a folder and its subfolders?