Rows to columns
utm0410
Registered Posts: 2 ✭✭✭
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
Best Answer
-
Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭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.