merge rows for the same keys

arkiboys 9,646 Reputation points

The attached screenshot shows a simple example of the many rows I have...
How is it possible to merge these rows into one row for the same keys.
In the example, the keys are: ml_name, mldocumentationName, ms_name
Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,718 questions
{count} votes

Accepted answer
  1. Nasreen Akter 10,761 Reputation points

    Hi @arkiboys ,

    You can use Aggregate in the Dataflow, Group By with the keys and aggregates the other rows with the aggregation functions for example first(), last(), sum(), avg() etc. Thanks!

0 additional answers

Sort by: Most helpful