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.
Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
The solution to last week's challenge is HERE.
This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this week's challenge, convert the string to a date using the following rules:
1) The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20.
2) It is 19 when the first character is 0 and 20 when the character is 1.
3) The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.
Example: 1040202 should become 2004-02-02.
... View more
The link to last week’s exercise (exercise #45) is HERE
I love to share real world use cases as exercises. This week’s exercise comes from a customer that had data coming from in a legacy system and needed to transform the date field for a new system. It is a straightforward exercise but shows how easily Alteryx can apply business logic to most any data transformation problem.
Use case: The Input contains dates formatted as year, month and day. In this case, the first character determines if the year should begin with 19 or 20. If the first character is 0 then the year starts with 19, and when the first character is 1 the year starts with 20. The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.
Objective: Please convert these strings into date formatted field.
... View more
A solution to last week's challenge can be found here.
This week's challenge focuses on a group of relatives and their birthdays. Of the six family members, we have one person's date of birth and a series of clues to calculate the others. Provide the DOB for all family members and the day of the week s/he was born.
... View more
Congratulations on completing Exercise 2!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
... View more
Congratulations on completing Exercise 1!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
... View more
