Transpose rows to columns

prabhakaran808 Dataiku DSS Core Designer, Registered Posts: 6 ✭✭✭


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


Setup Info
      Help me…