This was great for practicing filtering by date and taught me a new tool- DateTime.
I have never used the date feature before, and it is awesome! Using that first makes the rest of the problem very straightforward.
Employee_Solution.yxmd (14.5 KB)
challenge 8.yxmd (15.4 KB)
Great Challenge. At first I just tried changing HireDate to a Date using a Select tool. I had no idea what the DateTime tool did, but it was super useful once I discovered it! I also used text to columns instead of regex to parse the data. It worked fine because the comma was a common delimiter, but I see how RegEx would be super useful here!
TechHubAlteryxLoyaltyIncentiveChallenge.yxmd (14.0 KB)
1 Like
Here is the solution I got. I had trouble coming up with a way to automate it for when the current day is changing everyday but it works for today.
loyalty.yxmd (25.7 KB)
This was a great refresher on the basics of Alteryx. It wasn’t particularly challenging, but I still felt it helping my skills improve. Thanks for the challenge!
Challenge8AmyB.yxmd (15.9 KB)
I learned how to do multiple filters of a database in this challenge, this will be very useful for future data, thanks for the challenge!
EmployeeIncentive.yxmd (15.2 KB)
This took a lot of research to solve this challenge. I loved the opportunity learning how to use the DateTime. When I’m more experienced, I want to see if I can incorporate the DateTimeNow tool.
Homework for class 11.13.23
Here is what I have for this challenge! It was a great one, especially learning about the datetime tool.
TechHub practice.yxmd (80.6 KB)
This challenge was cool. I noticed they used the DateTime in the solution, but the data I had was already presented in that format, so I didn’t use the tool. Overall a cool challenge- I used the Replace function within RegEx to output the FullName in the right format
I struggled with filtering out the date time by years but I found a way to do it eventually. Great Challenge!
