Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

Transpose rows to columns

prabhakaran808
Level 2
Transpose rows to columns

Hi,

Below is my table. I want to convert the rows to column.

Actual Column.png

I use Prepare recipe to covert rows in to columns. It perfectly converts and showing the results as expected output. 

Recipe Output.png

However after running the recipe, Out put dataset shows result as below. Unlike the results in receipe output datset creates some empty rows. Am i missing anything here or it is system issue?

output dataset.png

I am expecting output to be shown all in one row.(Similar to recipe output).


Operating system used: Windows

0 Kudos
1 Reply
Madar
Level 2

Maybe a Pivot recipe will be better in your case ? 

0 Kudos