question

ranjeetkumarmodi avatar image
0 Votes"
ranjeetkumarmodi asked KranthiPakala-MSFT commented

How to map a global parameter to a dataflow to derive a column

I have global parameter Load_Date which will have today's Date "currentDate()" and i want to use in multiple dataflow to derive a column LOADDATE. Can anyone help me to find out how to use a global parameter in a dataflow?

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ranjeetkumarmodi,

Just checking in to see if the below suggestion from @MarkKromer-MSFT was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @ranjeetkumarmodi,

As @Kiran-MSFT suggested, could you please post the data flow script to better assist on your issue?

Thanks

0 Votes 0 ·

Hi there,

We still have not heard back from you. Just wanted to check if you still need assistance on this issue? If yes, please do share the DSL script to further assist on this.

Thank you

0 Votes 0 ·

1 Answer

MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered Kiran-MSFT commented

You would have to pass the parameter value to the data flow from the pipeline. Create a parameter inside the data flow and add the data flow to your pipeline. In the data flow pipeline activity, select the data flow parameter and set it with a pipeline expression. The pipeline expression fly-in panel will have the global parameter which you can use to pass to your data flow.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I followed what you have said, created a Global parameter and mapped it to Data Flow in the pipeline, then created a parameter inside the data flow, In the data flow pipeline activity, selected the data flow parameter and set it with a pipeline expression. But i am getting the below error "DF-EXPR-023 at DerivedColumn1'Parameter, Cyclic reference detected at data flow parameter ". Also when i validate the data flow i am getting error "parameter cannot be self referenced". Sorry to bother you this much, i am new in ADF.

0 Votes 0 ·

Post the dataflow DSL script(top right button on canvas)

0 Votes 0 ·