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

Creating new column and values from existing column/row values

HBarkdoll
5 - Atom

I currently have:

QuarterQ_CategoryQ_DescriptionValue
Q2petsdogs0.123456
Q3petsdogs0.123456
Q2petscats0.123456
Q3pets cats0.123456
Q2familymom0.123456
Q3familymom0.123456
Q2family dad0.123456
Q3familydad 0.123456

  

but need the data to look like this:

 

Q_CategoryQ_DescriptionQ2 ValueQ3 Value
petsdogs0.1234560.123456
petscats0.1234560.123456
familymom0.1234560.123456
family dad0.123456

0.123456

 

I am very new to Alteryx and am having a difficult time trying to move/separate these values. Any ideas would be great! Thanks!

3 REPLIES 3
Kenda
16 - Nebula
16 - Nebula

Hey @HBarkdoll! First you can use a Formula tool to change the value in your Quarter column using: 

 

[Quarter] + " Value"

From there, use a Cross Tab tool and group by Q_Category and Q_Description. Use Quarter as the new column headers and Value as your new column values. Hope this helps!

gnans19
11 - Bolide

Pivoting and aggregating would solve your issue. Attached workflow.

 

Untitled.png

AmeliaG
Alteryx
Alteryx

Thanks for your question!

 

The tool you are looking for is called the 'Cross Tab' tool. Here is a very helpful 'Tool Mastery' article for this tool. Additionally, I've attached a workflow which uses this tool to achieve your use case using your sample data. 

 

Hope this helps!

Labels