Skip to Content

pass parameters from script to data flow

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 14, 2012 at 10:39 PM

    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. 

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2012 at 08:19 AM

    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.

    Parameter.jpg (209.7 kB)
    Add comment
    10|10000 characters needed characters exceeded