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.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Thanks for the clarification. This workflow uses a regex formula to split the input columns into Type and Day and then a text to columns to split the day numbers into rows
After that, it's a question of how you want the output. The top output is the most useful for further processing since [Day number] is a single numeric value that you can convert to a day name or a date. The second output includes the "Day" label in the [Day] field. the third output is similar to the output you included in the original post