Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
For reference we are using Qlik Sense Feb 2023 and Qlik SaaS is not an option for us.
We are working on tracking data lineage on a few of our critical apps. The method is working for most of our apps and circumstances but its returning some apps as null. We use these apps as extracts, so they load the data into a table, push it into a QVD, and then drop the table.
All of those apps specifically are returning null responses and those are where a lot of our QVDs originate. I wanted to know if someone has more info.
Are there limitations that aren't listed? Or am I missing something? Just trying to find out if this is a viable option or if we should be going down another route.
There is an oddity about Lineage. When you drop a table, Lineage will also be dropped if there is no lineage earlier in the script.
Products:
SQL SELECT * FROM Products;
STORE Products ...;
DROP Table Products;
There will be no lineage. But if you do this:
Load 'dummy' AutoGenerate 0;
Products:
SQL SELECT * FROM Products;
STORE Products ...;
DROP Table Products;
You will have lineage for the Products table.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
There is an oddity about Lineage. When you drop a table, Lineage will also be dropped if there is no lineage earlier in the script.
Products:
SQL SELECT * FROM Products;
STORE Products ...;
DROP Table Products;
There will be no lineage. But if you do this:
Load 'dummy' AutoGenerate 0;
Products:
SQL SELECT * FROM Products;
STORE Products ...;
DROP Table Products;
You will have lineage for the Products table.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
This worked for me! Definitely some odd functionality but this is a great fix for what I'm currently working on.
Thank you for the help!