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 a long list of data

anujkasera
5 - Atom

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  
3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

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

DultonM
11 - 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 :)

anujkasera
5 - Atom

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

Labels