Re-assign project parameter value based on loop value in Job flow
I have given a parameter in my Data point schema object .
And in the job flow I am using a looper and assigning the values to the data point.
However I need to trim certain content of the Loop value and then re-assign to the parameter ?
Passing substring(‘$LP_LOOP’,1,7) in the data point is not getting accepted ,
can i do that on the fly in the job flow ?
You can use the project parameter in the datapoint related properties. But you cannot pass the functions in the project parameters.
Instead, you can perform the override at the job flow level — dataflow transforms — source instance.
Then you can include the looper parameter directly in the override as looper_param.table_name.