cancel
Showing results for 
Search instead for 
Did you mean: 

pass parameters from script to data flow

rajarshi_muhuri
Active Participant
0 Kudos

Hi

I will be executing a script that will in turn execute a stored Procedure in HANA. One of the outputs of the stored procedure would be value 'n'. I would like to pass that value to a data flow , which contains a SQL transform ( select  * from hana_table where time > n )

How do pass the parameter from script to data flow.

Rishi

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

  • Outside the dataflow in any one of the script declare a variable and assign some value in a script.
  • Use this parameter inside your dataflow
  • Declare this parameter inside the dataflow in the variable editor (2nd tab)
  • Assign the variable to this parameter which was declared in the script outside the dataflow.
former_member213365
Active Participant
0 Kudos

The Dataflow has parameters.  When you are in the Dataflow go up on the menu and click the variables icon and then on the Parameters item in the dialog.

Dataflow parameters are IN only.  You cannot pass a variable into a Dataflow and have the Dataflow update the variable and see that change in an object after the Dataflow runs.