Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Transpose to Crosstab and appending field names



trying to get specific field names based on my data.  I get to a certain point and I am stuck.

The image below is my sample input and expected output.  I also included a workflow sample.


Alteryx Certified Partner

Hey @LincolnMike


This should get you somewhere close.


  • I transposed the data first
  • created a concatenated header
  • did a little regex replace (because crosstab annoyingly removes special characters)
  • used summarize to count the number of "tracks"
  • Crosstabbed the data back
  • lastly a little dynamic rename to put the special characters back in the headers


Transpose Crosstab.PNG@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

Hi LNL. I will try this first thing Monday morning

Thank you LNL.  I used the REGEX you created.  I spent the day understanding the formula, and found more information about REGEX.  I found a site and the Alteryx help site.  I added a few more Formulas to what you started for me and i have all that I need...for this question :)

I am sure I will have more questions soon.