topic Re: How to Fetch Field Names used in a Qliksense Application by using log script in App Development

How to Fetch Field Names used in a Qliksense Application by using log script

Jahnavi — Mon, 20 Dec 2021 21:08:46 GMT

Hi Friends,

I would like to fetch the Field names used in an application by using the Log script of a particular application.

For Example if a log script is having below details:

2020XXXXXXXXXXX.XXX+XXXX 0130 LOAD
2020XXXXXXXXXXX.XXX+XXXX 0131 "Customer_Code" AS CustomerCode,
2020XXXXXXXXXXX.XXX+XXXX 0132
2020XXXXXXXXXXX.XXX+XXXX 0133 "Customer_NameAS Customer,
2020XXXXXXXXXXX.XXX+XXXX 0134 FROM [lib://DEV/Customer.qvd]

I want to find the Field Name Before Alias 'AS ' and After Alias 'AS', Such as

Field Name, Before Alias Field Name

CustomerCode,Customer_Code

Customer, Customer_Name

Thanks in Advance

Re: How to Fetch Field Names used in a Qliksense Application by using log script

Jahnavi — Wed, 24 Jun 2020 10:18:29 GMT

Could you please help me with this.

Re: How to Fetch Field Names used in a Qliksense Application by using log script

Or — Wed, 24 Jun 2020 10:49:38 GMT

You'd have to load the script file, look for all instance of ' as ' within a row, and then get the string directly before that. Even then, you wouldn't necessarily know which part of the string to get - it may have spaces, it may or may not be enclosed by quotes or brackets, etc.

There are tools that give you the data lineage for a Qlik Sense app (or multiple Qlik Sense apps), I'd recommend you investigate one of these instead of trying to make your own from scratch.

Re: How to Fetch Field Names used in a Qliksense Application by using log script

Jahnavi — Mon, 29 Jun 2020 07:03:30 GMT

I have taken metadata information for QVD's by loading it as XML Files.

Is it possible to write a subroutine in qvf files and pull the metadata information from qvf? Please share me samples if available.