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

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!

merge rows for the same keys

Accepted answer

Nasreen Akter 10,791 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!
Please sign in to rate this answer.
arkiboys 9,686 Reputation points

2022-03-24T14:34:11.46+00:00

can you show me for this example attached so that I understand what you mean?

field1 field2 field3 field4 field5 field6 --------------------------------------------------------------------------------------- company1 add1 xyz 9.5 NULL NULL company1 add1 xyz NULL 56.99 NULL company1 add1 xyz NULL NULL 4555 company2 add2 utg NULL NULL 65655 company2 add2 PWB 7777 NULL NULL ...

Nasreen Akter 10,791 Reputation points

2022-03-25T14:35:25.217+00:00

Hi @arkiboys , would you please tell us what's the expected output. Thanks!

arkiboys 9,686 Reputation points

2022-03-25T15:44:15.753+00:00

Hi, Something like the below screenshot. So that the rows are not repeated for the same key(s) and they go into one row field1 field2 field3 field4 field5 field6

company1 add1 xyz 9.5 56.99 4555
company2 add2 utg NULL NULL 65655
company2 add2 PWB 7777 NULL NULL
...

Nasreen Akter 10,791 Reputation points

2022-03-25T17:42:26.643+00:00

Hi @arkiboys ,

Please see the screenshots below. Thanks!
Sign in to comment

Share via

merge rows for the same keys

Hi, Something like the below screenshot. So that the rows are not repeated for the same key(s) and they go into one row field1 field2 field3 field4 field5 field6

0 additional answers