Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can any one guide me steps to build data lineage

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

7 Replies
swuehl
MVP
MVP

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

Maybe start with the governance dashboard and its lineage tab.

Not applicable
Author

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
MVP
MVP

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

Not applicable
Author

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:

SourceTableSourceTypeCountrySourceFieldsLinkFieldNo
IDR_SourceTable1MeasureCountryNameField1IDR_3
IDR_SourceTable2DimensionCountryNameField2IDR_10
IDR_SourceTable3.xlsxDimensionCountryNameField3IDR_14

EXTRACT sheet:

ExtractTable

Extract FieldLinkFieldNo
ZAR_ExtractTable1Field1ZAR_5
ARS_ExtractTable2Field2ARS_99
IDR_ExtractTable3Field3IDR_14

TRANSFORM sheet:

ETLNameTransformedFieldsTransformedFieldTypeLinkFieldNoRemarkRemark1
ETLName1Field1DimensionIDR_18
ETLNAME2Field2MeasureIDR-16
ETLNAME3Field3DimensionIDR_3

LOADING sheet:

QVDTableQVDFieldNameLinkFieldNo
Cust1Customer_CodeARS_5
Cust2CustomerGBP_17
Cust3Customer_CountryZAR_14

QVDMAPPING sheet:

ApplicationTableApplicationFieldsApplicationLabelLinkFieldNo
FACTNET_SALESIDR_6
MATERIALMATERIAL_NAMEARS_7
CUSTOMERCUSTOMER_SOURCEZAR_17

PHOTOOperation sheet:

SheetNameSequenceApplicationLabelLinkFieldNoRemarks
Sheet1AOP SalesARS-27
Sheet2YearZAR_7
Sheet3BUIDR_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
Partner - Contributor III
Partner - Contributor III

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

fredriksevieri
Partner - Contributor
Partner - Contributor

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