Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

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

1 Reply
Manuel
Dataiker
Dataiker

Hi,

You either use a...

I hope this helps.

Setup info

?
Tags (1)
A banner prompting to get Dataiku