merge rows of same file Azure data factory

CORONADO GRANADOS Diana Milena 126 Reputation points
2020-07-03T13:02:35.68+00:00

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
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,077 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful