can we transpose rows to column without aggregate using dataflows

Question

can we transpose rows to column without aggregate using dataflows

BalwinderKaur-5937 41

I need to transpose rows into columns without aggregating any values, is it possible to do that using dataflows, tried pivot option but it requires the aggregate function.
Sample data:
Field 1 Value1
Field 2 Value2
Field 3 Value 3
Result Needed:
Field1 Field2 Field3
Value1 Value2 Value3

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-02-17T05:56:58.193+00:00

Hello anonymous user,

Just checking in to see if the below answer provided by Mark Kromer was helpful. 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.

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-02-17T05:56:58.193+00:00

Hello anonymous user,

Just checking in to see if the below answer provided by Mark Kromer was helpful. 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.

Answer 1

MarkKromer-MSFT 5,226 Microsoft Employee Moderator

There is not a native Transpose function in ADF. However, there are some clever ways to use Unpivot w/Pivot that have been devised to provide similar functionality. Here is an example: https://learn.microsoft.com/en-us/answers/questions/629521/transpose-data-using-adf.html

Share via

can we transpose rows to column without aggregate using dataflows

1 answer

Your answer