topic Re: Output Lineage Output from Get App Information block in Qlik Automate

Output Lineage Output from Get App Information block

Ericga — Thu, 22 Aug 2024 21:38:42 GMT

I am trying output the app lineage but not quite successful so far. i can get the lineage to output but can't tie any of the other app information to it such as the app name or id. Anytime i try to add id or name to the output the lineage information just displays as "Array" and is blank. I've tried writing it to a list and table variable but they do the same thing. i even put the list variable in a loop and tried to write it line by line but when i put the app name or id variable in front of it it wipes it out and just displays "Array".

how can i get the lineage to output properly in an Automation?

Thansks in advance!

Re: Output Lineage Output from Get App Information block

salmankojar — Fri, 23 Aug 2024 06:50:16 GMT

Hi @Ericga it would be better if you attach your flow so we can easily understand your isssue and we can help you accordingly.

Re: Output Lineage Output from Get App Information block

Ericga — Fri, 23 Aug 2024 13:10:23 GMT

Thanks Salmankojar. I should have done that to start with. The json is attached as well as a description of how the automation works.

I list out all apps from a particular space with the List Apps Block. (Currently it does not show a space as I took it out for this upload purpose so insert your own space there) I use the Get App Information block to retrieve the app info and place the AppName into a string variable and the App Lineage into a list variable. I then Loop through the Lineage list variable. The various output block below are what is being used for testing. They can be disabled and enabled to see the different results. Each Output blocks purpose is listed below.

Output 5 lists each item as the Loop iterates and it lists the Lineage items correctly.

Output 7 is where I try to place the AppName variable to the output along with the Lineage info and this is where it loses the Lineage info and just shows it as “Array”.

Output 2 is where I originally started trying to output the Lineage using the Lineage straight from the Get App Information Block. It outputs correctly.

Output 3 is the same as Output 2 except I added the App Name. This causes the Lineage not to output and just shows the work “Array”

My main goal for this is to output the Lineage info out to a csv file and then use it in an app to do some analysis on the lineage, but I need to tie the Lineage info to the App Info(Name, Id, etc) in order for it to work correctly