Transpose to Crosstab and appending field names

[LincolnMike]

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.

[LordNeilLord · Accepted solution]

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

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[LincolnMike]

Hi LNL. I will try this first thing Monday morning

[LincolnMike]

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.