Qlik Cloud Lineage graph does not show all nodes of an ETL process

Andreas_Giesbrecht — Tue, 20 Sep 2022 10:15:17 GMT

The lineage graph might not show the whole ETL process in the Qlik Cloud Services, but instead only one node like for example in the following screenshot:

However the expected result would be the whole graph as seen in here:

The unexpected result seems to be caused by the lib statements in upper case in the store statements for the QVD creation and/ or missing brackets in the store statements in the load script, please find an example script for a failed lineage down below:

//APP Extract [People]: LOAD * inline [ ID,Name,Job,EMail,Address,DateOfBirth, Country A, B,C,D,E,F,G ] ; STORE [People] into [LIB://:DataFiles/People.qvd] (qvd); Drop table [People]; //App Transform [People1]: LOAD ID, num(0.01*[ID],'0%') as [ID_test], [EMail] as [Email_adress], Upper([Job]) as Job_Name, pick(match([Country], 'U', 'S', 'K','N'), 'Denmark', 'Sweden', 'Finland', 'Norway') as [Country], dayname([DateOfBirth]) as [Date of birth] FROM [LIB://:DataFiles/People.qvd] (qvd) ; Store [People1] into LIB://:DataFiles/People1.qvd (qvd); DROP TABLE [People1]; //App Load People2: LOAD ID, ID_test, Email_adress, Job_Name, Country, "Date of birth" FROM [lib://:DataFiles/People1.qvd] (qvd);

Environment

Resolution

R&D is working at the moment on this issue, there is no ETA for a fix available.

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-14302 for reference.

Workaround:

Please make sure that all lib statements are in lower case and include according brackets as for example "STORE [People] into [lib://:DataFiles/People.qvd] (qvd);"

Cause

Product Defect ID: QB-14302

article Qlik Cloud Lineage graph does not show all nodes of an ETL process in Official Support Articles

Qlik Cloud Lineage graph does not show all nodes of an ETL process

Environment

Resolution

Workaround:

Cause