Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Rows to columns

Solved!
utm0410
Level 1
Rows to columns
 
 

See attached file - for each Measure that shows in the column, I want to transpose those measures to a column and have the corresponding amount in the value column to show in the related measure 

This:

Measure                                Value

Gross                                      6047.88

General Discounts               (1.40)

Selling Expense                    4237.00

Samples                                 2.30

Media                                     146.82

Becomes This:

Gross           General Discounts          Selling Expense    Sample   Media

6047.88                 (1.40)                     4237.00                 2.30        146.82  

 
1 Solution
Manuel
Dataiker
Dataiker

Hi,

You either use a...

I hope this helps.

View solution in original post

The Pivot Recipe transforms datasets into pivot tables, which are tables of summary statistics. This operation can also be referred to as reshaping from long to wide format. This video is featured in the "Visual Recipes Overview" course on Dataiku Academy. See the Open course ...
1 Reply
Manuel
Dataiker
Dataiker

Hi,

You either use a...

I hope this helps.

The Pivot Recipe transforms datasets into pivot tables, which are tables of summary statistics. This operation can also be referred to as reshaping from long to wide format. This video is featured in the "Visual Recipes Overview" course on Dataiku Academy. See the Open course ...

Setup info

?
Tags (1)
A banner prompting to get Dataiku