Azure Data Factory - Data Flow - parameters in group by

Question

Hi, I want to use parameter in Azure Data Factory Mapping Data Flows to determine which columns will by used to group by in Aggregation tool. I used Array as parameter type.

I used this parameter in group by in aggregate tool.

However in the results tab I can see one column as an array instead of multiple columns.

My Goal is to have a parameter with list of columns. Each columns will be used as a separate column in group by in Aggregate tool?

Answer 1

Hi @Gabryel, Andrzej ,

if you add column pattern in the aggregates tab with the following expression you will get all the groupBy columns you have passed in the test array parameter(please see the screenshots below):

in($test, name): this expression will give you all the GroupBy columns you have passed in the parameter
!in($test, name): this expression will give you all the other columns in the table except the GroupBy columns you have provided in the parameter

Please let me know if this helps. If the above response helps, please "accept the answer" and "up-vote" the same! Thank you!