Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.