This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Learn MoreI 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
Site | Period | Revenues | Units | Customer Type |
1 | TY | 100 | 10 | A |
1 | TY | 95 | 11 | B |
1 | LY | 105 | 9 | C |
Desired
Site | Agg | Metric |
1 | TY Rev A | 100 |
1 | TY Units A | 10 |
1 | TY Rev B | 95 |
2 | ||
2 |
Solved! Go to Solution.
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!