topic Re: Track a created field from original name in QlikView

Track a created field from original name

LeeSmithBtn — Sat, 16 Nov 2024 05:15:10 GMT

Hi,

this may well have been asked before and it may well not be possible in the slightest... but ill ask anyway...

so i have access to the Meta Reader Qvw of which i can load in a QVD and tells me the creator doc and the fields contained within that QVD...

but my question is:

is it possible in anyway to see the tracking of a field from start to finish... for example.

field a = 1 in raw file store in qvd.

load field a + 1 as field b store into transform qvd.

load field b end user app.

is there anyway to find that field b was created from field a but with a calculation added?

sorry for the long winded question, but would really help me map all fields and processes to define if fields are being duplicated and re-used across multiple apps.

thanks in advance

Re: Track a created field from original name

Vegar — Wed, 14 Nov 2018 18:23:25 GMT

You might be helped by the "Lineage / Dependency Analyzer for QlikView".

https://community.qlik.com/t5/QlikView-Documents/Lineage-Dependency-Analyzer-for-QlikView/ta-p/1490316

Re: Track a created field from original name

LeeSmithBtn — Wed, 14 Nov 2018 18:29:47 GMT

thanks Vegar,

i have access to this app, although i can see the lineage of apps and qvd linkage i couldn't seem to see anyway of tracking individual fields.

unless there is something i'm missing

thanks

lee

Re: Track a created field from original name

Vegar — Wed, 14 Nov 2018 18:36:52 GMT

To track all the way out to an object might not be an easy task. I guess you could start analyzing the application xml files if you create prj-folders for all apps.

Alternatively there are products available on the market that extend the data lineage analysis . I saw a demo of the NodeGraph system a couple of months back, it does exactly what you're asking for. Check it out.

Re: Track a created field from original name

rwunderlich — Thu, 15 Nov 2018 00:31:30 GMT

The only solution I know of that provides field level lineage for QV is NodeGraph.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Track a created field from original name

LeeSmithBtn — Mon, 19 Nov 2018 19:26:26 GMT

thank you for the reply, i will check this out and see if it is suitable. but by the looks of things it does do as i want.

thank you and kind regards.

lee