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?
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?
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.
As @Kiran-MSFT suggested, could you please post the data flow script to better assist on your issue?
Thanks
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
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.
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.
6 people are following this question.