I have a csv file data like below :

I want to achieve data like below :

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
I have a csv file data like below :

I want to achieve data like below :

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
Hello @ArundhatiSen-2743,
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
Hello @ArundhatiSen-2743,
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.
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
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://docs.microsoft.com/en-us/answers/questions/629521/transpose-data-using-adf.html
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
9 people are following this question.