Rows to columns

utm0410

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

Manuel

Hi,

You either use a...

• Pivot processor in a Prepare recipe, see https://doc.dataiku.com/dss/latest/preparation/processors/pivot.html
• or a Pivot recipe, see https://www.youtube.com/watch?v=NXkfcg7IWlw

I hope this helps.