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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Transpose to Crosstab and appending field names

Asteroid

Hi,

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.


iNPUT_OUTPUT.JPG

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

Asteroid
Hi LNL. I will try this first thing Monday morning
Highlighted
Asteroid

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 regex101.com 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.

 

Labels