Pass variables from one transform map into Another within a data source

[Mussie]

Hi Guys,

I am inserting records to three tables using three transform maps, but I want to have the sys_id of the first record to be passed to the second transform map, as that is the child of of the first one. Any idea how can I do this?

All these transform maps are part of one data source. I tried declaring a variable on the OnAfter of the first transform map but coming empty on the second transform map.

Thanks,

Mussie

[Yash Agrawal1 · Accepted solution]

Hello Mussie,

I don't think we can transfer one value of transform to another transform map, but the solution could be after executing the first transform map the records will get updated.so you can apply a query to fetch record for 2nd transform map.

Please Mark it helpful/correct if my answer helps in any way to resolve your query.
Reach out to me if any more help required.

Regards

Yash.K.Agrawal

[Ankur Bawiskar]

Hi,

There is limitation that you cannot pass the global variable across transform maps.

As an alternative you can try using this approach

1) create a system property of type string

2) in the 1st transform map script you can set the property value

3) in the next transform map script you can get the property value using gs.getProperty('property_name');

check below links

Transform Map onStart event scripts can no longer declare global variables

Transformation script variables

Regards
Ankur