question

CORONADOGRANADOSDianaMilena-8538 avatar image
0 Votes"
CORONADOGRANADOSDianaMilena-8538 asked CORONADOGRANADOSDianaMilena-8538 commented

merge rows of same file Azure data factory

Hello
I need to merge multiple rows into one row in azure data factory, per example I have the following file

PolicyId Driver_name
0001 Adam
0001 Lucy
0002 peter

At the end I need to have
PolicyId Driver_name1 Driver name2
0001 Adam Lucy
0002 peter

I don't see any option on the data flow activity to do it, please can you help me??

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MarkKromer-2402 avatar image
0 Votes"
MarkKromer-2402 answered CORONADOGRANADOSDianaMilena-8538 commented

Use the collect() function inside of an Aggregate transformation to combine row values together into an array.

https://www.youtube.com/watch?v=zneE18EHJSE

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Many thanks mark!!! it helps me a lot!

1 Vote 1 ·