Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Breaking a column into multiple columns (category, sub-category, etc.)

QuestAlt
5 - Atom

Hi,

 

I have a financial data that has categories and sub categories in one single column - let's say Revenue as category, and multiple sub-categories for it. The total revenue represents the total of this sub-categories. Now, I would like to Have column 1 that has Revenue as its values for all the rows, and Column 2 that has those sub-categories as values.

 

Changing:

Revenue 
Sales Product 11000
Sales Product 22000
Total Revenue3000
Costs 
Cost 1-500
Cost 2-900
Total Cost-1400

 

 

To:

RevenueSales Product 11000
RevenueSales Product 22000
RevenueTotal Revenue3000
CostsCost 1-500
CostsCost 2-900
CostsTotal Cost-1400

 

 

Or even better, to:

 

Revenue Sales Product 11000
Revenue Sales Product 22000
RevenueTotal Revenue 3000
Costs Cost 1-500
Costs Cost 2-900
CostsTotal Cost -1400

 

Any help to do this in Alteryx, or should I do it in Excel?

 

Many thanks,

Dan

2 REPLIES 2
Ar13f
10 - Fireball

Dear @QuestAlt 

 

please find the workflow ... I hope this is what you want. I use multi-row formula to give remarks "Revenue" and "Cost" 

 

QuestAlt.png

QuestAlt
5 - Atom

Thank you - did the trick!

Labels