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

[Andreas_Giesbrecht]

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

• Qlik Cloud 

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