Overview
You are working for a company and the CEO has decided to give a “loyalty incentive” to their employees. They decide to have two different rewards based on the amount of time an employee has been with the company. The CEO wants the cut-off to be five years for the first tier and the next cutoff to be 10 years and beyond.
Instructions
The CEO has tasked you with finding these employees. They would like to see a report of all employees that fall in the first cutoff of five years and the second cutoff of ten years plus. Output both lists to a browse tool. You should display the following headers in your solution:
With the full name being displayed like “John Smith” and you should sort both lists by HireDate descending.
Make sure to have the HireDate as a date and not a string! (Look for the DateTime tool if stuck) RegEx (more challenging) or Text-to-columns could be helpful to parse the names.
That’s awesome, I haven’t had much practice with date manipulation! I did mine very similar, But I only used one select right before the filters to minimize elements thrown in. Great challenge, filtering data by date is pretty sweet!
This was a quick and fun challenge! A great way to solidify the need to know your variable types.
I found using a formula tool instead of regex made it easier as I could use LEFT/RIGHT/FIND to skip an extra step. Sorting the HireDate before filtering also reduced the need for extra tools.
I’m still a little rusty getting back into Alteryx, but I really liked this challenge. I ended up using the text to columns tool to split the name on the comma and then combine them later with the formula tool, but the solutions posted are a lot cleaner, which I hope to use in the future.
Great challenge! I have only used the DateTime tool a few times so that was good practice. I ended up using the text to columns instead of using RegEx but I saw your solution and that was an awesome use of RegEx. Thanks for putting this together! Here is the workflow that I created:
This was a great challenge that required creative solutions to a very simple problem: date formats not working. Using RegEx after that was very helpful to get to exactly what I was looking for.
This challenge was good exposure to the DateTime tool. Before using it, I tried to change the data type of the Hire Date field through a select tool, which gave me null values. Its good knowing that the DateTime tool is available, and how it can be used!
It’s amazing how trying these first on my own…I make it way more complex than it needs to be. Just getting familiar with a single tool in Alteryx can eliminate 2-3 steps! Fun challenge!
I decided to add an extra column showing how Many years the employee has been with the company, order by years in the company ascending and split it in two sets of results:
A) 5-9 years with the company
B) 10+ years with the company
