question Re: Setting and Reusing Variables During Import Transform in Developer forum

Setting and Reusing Variables During Import Transform

MGanon — Fri, 20 Mar 2020 13:19:05 GMT

During an import, how do I set a variable once and reference it during other transform map stages?

We have an import that 5 different scripts:
     3 Transform Scripts: onStart (1), onBefore(2), & onAfter (5)
     1 Field Maps script (3) to identify the sys_id by multiple criteria
     1 "base" script on the Table Transform Map screen (4)

Each script has a different purpose but the scripts share certain variables of the same values calculated with the same criteria. How can I calculate the variables once and reference them in the other scripts?

I believe that the scripts process in the following order: onStart (1), onBefore(2), Field Maps script (3), "base" script (4), & onAfter (5). The onStart script only initializes (gs.include…) our custom version of the LDAPUtils Script Includes. The other scripts call additional scripts from our custom version of the LDAPUtils Script Includes.

Re: Setting and Reusing Variables During Import Transform

sachin_namjoshi — Fri, 20 Mar 2020 15:34:02 GMT

Declare variable in an onStart script and it's available to other scripts within the transform process.

Regards,

Sachin

Re: Setting and Reusing Variables During Import Transform

MGanon — Sat, 28 Mar 2020 17:21:50 GMT

For clarity: "this." and not "var " in front of the variable.

Declaring a "var " variable in an onStart script does not set that variable for the rest of the transformation but a "this." variable does. Example: importBudgetItemTransform transform map

For example, add this to the onStart map:
var DeclaredVar = "Declared Variable";
this.thisvar = "this.variable for whole map";:

The rest of the scripts (onBefore, field mapping, run script, onAfter, etc.) will read and can use the "this.thisvar" variable but abend with the "DeclaredVar" variable.

Re: Setting and Reusing Variables During Import Transform

Ankur Bawiskar — Sun, 12 Apr 2020 14:54:24 GMT

Hi,

So if you declare a variable using this keyword then it is accessible in all other further scripts

Regards
Ankur

Re: Setting and Reusing Variables During Import Transform

Goran — Thu, 15 Apr 2021 09:49:57 GMT

Thank you for providing the first clear explanation (that I could find) on declaring variables usable throughout an import transform.