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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Reformatting/Transforming Data

Hey Everyone,

 

I have some data that I'm trying to reconfigure so it is better suited for Tableau.  I've tried out transpose and crosstab and haven't been able to get the result I want. I feel like I'm overthinking the issue at this point. I've attached a photo of what I'm trying to accomplish and a photo of my current workflow. Can I accomplish this tasks with some combination of formula tool (add new column) and transpose or cross tab?

 

alteryx excel example.PNGfile drop.PNG

 

Thanks!

Yes this is doable

 

2018-12-11_07-34-09.png

 

Use a transpose tool to flip it to be rows and then you can use a find and replace to change the original headers to what you need.

 

Sample attached

Labels