ADF Create Dynamic Dataflow

Question

Hi everyone,

I am trying to build a fully dynamic Dataflow.
Everything like table name, column name should be parameterized.
I want to use the dataflow to count based choosen columns.
So far i managed to parameterize the "source" and the "select rows".
Its not possible to parameterize the "aggregate Flow".

Any Ideas how to do it ?

Here is the dataflow

Here are the parameters

Answer 1

Hi @Waleed Saleem ,

Thank you for posting query in Microsoft Q&A Platform.

Thanks for asking query in english. But screenshot was not in english hence little unclear on understanding implementation here. It would be great if you share screenshot also in english along with exact requirement in aggregate which you are trying to acheive.

However, It seems you want to point a column name which is actually a value in parameter. If this is true, then kindly consider using byName() function in dataflow, which helps to refer to column name dynamically.

Hope this helps. Please let us know how it goes.