Access Source value from Transform Query in a Global/Local Variable in CPI DS

[Vimalsap]

Dear Experts,

I need a solution to read the source value from the Transform query in CPI DS to a Global/Local Variable either in Script or in the mapping editor.

This is required to be used in 1st Data flow and read the variable in 2nd Data Flow of the same Job.

Regards

Vimal

[jeffrey_kresse]

Global variables can only be set in scripts or prior to runtime in Execution Properties/Run Now prompt. To my knowledge there is no way to assign mid transform.

https://help.sap.com/viewer/dab65b1584e04026a132a06a711e3f5a/Cloud/en-US/649289fc1a5a41988762fc88e51...

How would you guarantee a certain row's value is saved in the variable? Perhaps you could use a lookup function in 2nd dataflow to get the same result as a variable.

Regards,

Jeff K