Can any one guide me steps to build data lineage

[#1]

Hi Qlikers,

Need to build data lineage for the client. So any help on the same would be appreciated.

Any documents related to the process carried out for the same would help.

twa‌

Regards,

Pratik

[swuehl]

That's a big topic for one morning...

Maybe start with the governance dashboard and its lineage tab.

[swuehl]

Then read also through

Data Governance & Data Management with QlikView & QlikView Expressor

Re: Listing QVD and File Extensions in Script‌

QlikView Governance Dashboard

[#4]

Thanks for the response swuehl.

After surfing through the internet I got a Qlikview file along with the source excel file which has the respective sheets of :SOURCE,EXTRACT,TRANSFORM,LOADING,QVDMAPPING and PHOTOOperation. Do you or anyone in the community have any idea about the steps/process to create this excel file. I think this will solve the purpose.

gwassenaar‌

Regards,

Pratik

[swuehl]

I think it would be helpful if you post the link to that QVW and Excel so we know what you are talking about?

[#6]

Hi Swuehl,

The apps were downloaded by other resources long ago, so don't have the links and cant paste the app. But Ill share the format of the excel sheets.

SOURCE sheet:

SourceTable	SourceType	Country	SourceFields	LinkFieldNo
IDR_SourceTable1	Measure	CountryName	Field1	IDR_3
IDR_SourceTable2	Dimension	CountryName	Field2	IDR_10
IDR_SourceTable3.xlsx	Dimension	CountryName	Field3	IDR_14

EXTRACT sheet:

ExtractTable	Extract Field	LinkFieldNo
ZAR_ExtractTable1	Field1	ZAR_5
ARS_ExtractTable2	Field2	ARS_99
IDR_ExtractTable3	Field3	IDR_14

TRANSFORM sheet:

ETLName	TransformedFields	TransformedFieldType	LinkFieldNo	Remark	Remark1
ETLName1	Field1	Dimension	IDR_18
ETLNAME2	Field2	Measure	IDR-16
ETLNAME3	Field3	Dimension	IDR_3

LOADING sheet:

QVDTable	QVDFieldName	LinkFieldNo
Cust1	Customer_Code	ARS_5
Cust2	Customer	GBP_17
Cust3	Customer_Country	ZAR_14

QVDMAPPING sheet:

ApplicationTable	ApplicationFields	ApplicationLabel	LinkFieldNo
FACT	NET_SALES		IDR_6
MATERIAL	MATERIAL_NAME		ARS_7
CUSTOMER	CUSTOMER_SOURCE		ZAR_17

PHOTOOperation sheet:

SheetName	Sequence	ApplicationLabel	LinkFieldNo	Remarks
Sheet1		AOP Sales	ARS-27
Sheet2		Year	ZAR_7
Sheet3		BU	IDR_18

This is the sample format of the sheets which are there.. Any idea how they must have been fetched/created?

Need help urgently!

Thanks in Advance,

Pratik

[v_petrenko]

Hi Pratik, I've developed a QV App for this specific purpose, suggest you try it!

[fredriksevieri]

Hi Pratik!

NodeGraph is a great data lineage tool for both QlikView and Qlik Sense. Feel free to head over and have a look for yourself, or send me an email if you want to know more

NodeGraph - Your Data Starts Here