Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
CariceHouten
Contributor
Contributor

Extracting field transformation from app load script [Qlik Sense]

Is there a way, using the API, to retrieve the transformations applied to a field during the data load script?

For example:

MyTable:

LOAD num(mystringfield) as MyNumField

RESIDENT tmp_table;

I'd like to retrieve the final field name (MyNumField) as well as the transformation applied (num(mystringfield)).

I know some tools like Nodegraph do this kind of task (lineage) but we're not big enough to warrant such a tool and was also interested in trying it myself. I have been unable to find this information so far.

1 Reply
Dalton_Ruer
Support
Support

There is an API that you can call to get the script code for the app, conveniently named getScript. https://help.qlik.com/en-US/sense-developer/November2020/Subsystems/APIs/Content/Sense_ClientAPIs/Ca...

Parsing the code is why partners like NodeGraph charge for the tremendous amount of work that they have done handling all of the many transformation scenarios that Qlik handles.