Extracting field transformation from app load script [Qlik Sense]

[janilpebo]

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.

[vikasmahajan]

MyTable:

LOAD num(mystringfield,'##.##0' ) as MyNumField

RESIDENT tmp_table; 

you need to add number format in your script.

Vikas