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

[Jahnavi]

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

[Jahnavi]

Could you please help me with this.

[Or]

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.

[Jahnavi]

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.