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.
I used text to columns, data cleanse, and date conversion.
This is how I arrived at the solution.
Text to Columns, Formula and DateParse.
I liked working on this one as its a quick parsing activity
Looking at the solution now, I think I could've combined two of the tools I used with one. I learned about a new function too!
Awesome!! This is great way to learn alteryx.
Learnt to write formals to parse the date and remove delimeters.
First weekly challenge! Solution attached.