merge rows for the same keys

arkiboys 9,646 Reputation points
2022-03-24T13:59:23.783+00:00

Hello,
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
    2022-03-24T14:11:50.31+00:00

    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