Transpose File using ADF Mapping DataFlow

Arundhati Sen 151

I have a csv file data like below : ![182916-image.png][1] I want to achieve data like below : ![182867-image.png][2] Here first 4 columns have same row values and last 4 columns have separate row values. Please help me how to achieve this using ADF Mapping DataFlow [1]: /api/attachments/182916-image.png?platform=QnA [2]: /api/attachments/182867-image.png?platform=QnA

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-03-15T02:46:18.04+00:00

Hello anonymous user,

Thanks for the question and using MS Q&A platform.

My understanding is that you would like to implement transposing data using Mapping dataflow in ADF.

You may achieve your requirement using unpivot and pivot transformations in ADF mapping flow.

Not sure if you have already gone through these related threads but please refer to this thread where there is a step-by-step explanation about the implementation for transposing data and see if that helps to achieve your desired result - Transpose Data using ADF

Here is also another thread where a similar implementation was discussed: Can we do transpose of data in Azure Mapping Data Flow?

Hope this helps. Please let us know if you have any questions while implementing.

Thank you
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-03-16T05:02:45.527+00:00

Hello anonymous user,

Just checking in to see if the any of the answers helped. If it answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Arundhati Sen 151 Reputation points

2022-03-16T10:43:26.2+00:00

I tried the pivot unpivot option but I am not getting the required output. If you check my source data and target data and try to replicate it to show as an example it will be very helpful

1 answer

MarkKromer-MSFT 5,186 Reputation points Microsoft Employee

2022-03-15T00:17:08.873+00:00

There is not a direct Transpose function in ADF. But there are a few creative examples of using unpivot in the community, i.e.: https://learn.microsoft.com/en-us/answers/questions/629521/transpose-data-using-adf.html
Please sign in to rate this answer.
Arundhati Sen 151 Reputation points

2022-03-16T10:46:27.253+00:00

I tried pivot unpivot but not able to achieve required target data. If you see my source data, In field column there are duplicate field names and when I am trying to pivot it only able to get any one of the values corresponding to those fields
Sign in to comment