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

Alteryx designer Discussions

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

Creating a long list of data

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