community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Creating a long list of data

Highlighted

I need to arrange my data in a table which has only 3 columns - Site ID, attribute aggregation (Time + Metric + Type), Metric value. I tried using the transpose but that is not working. Can someone please suggest the best way to do this? Thanks!

 

 

Current

SitePeriodRevenuesUnitsCustomer Type
1TY10010A
1TY9511B
1LY1059C

 

Desired

SiteAggMetric
1TY Rev A100
1TY Units A10
1TY Rev B95
2  
2  

First use a Transpose table to convert to Site, Period, Customer Type, Name, Value

You can then use a Formula tool to make the Agg field

Finally a select to rename and drop columns

Bolide

Hi anujkasera!

 

You're almost there! To add to jdunkerley79's post:

 

Choose Site, Period, and Customer Type as your "Key Fields" in the Transpose tool. I've attached a workflow (built in 10.5) that demonstrates this and the Formula/Select tools that should follow.

 

UPDATE: Oops! Didn't realize jdunkerley79's post also included a workflow! Looks like you get extra assurance that this'll work :)

That worked! Thank you for the help jdunkerley79 and DultonM. Very helpful!

Labels