CODEWITHSUNDEEP
azureazure-data-factory
user989988
user989988

Reputation: 3736

Return count in ADF Data Flow

I have an ADF Data Flow that outputs 2 sets of values (Name, Location) as shown below:

enter image description here

enter image description here

Is there a way to output the count of Names in each Location via ADF Data Flow?

Upvotes: 0

Views: 3868

Answers (1)

suresiva
suresiva

Reputation: 3173

You can do it with Aggregate action. I tested it with your data.

enter image description here

  1. Start with Aggregate action's Group by section, add location as group by columns.

enter image description here

  1. Mention aggregated column name in the Columns and count(name) as aggregate expression.

enter image description here

  1. Verify the aggregate's result in Aggregate's Data preview

enter image description here

Upvotes: 3

Related Questions