Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Thanks for setting this one!
James
I like the number of different solutions! Representing Data Prep U with our solution.
Thanks for a good presentation today on the challenge.
I went back to try to solve, and did. The one thing that I did not like was how the posted answer fabricated "Removed Date" = 7/1/2019 for those rows that did not have a Removed Date. My solution maintains a Removed Date of Empty (null), which I feel is more accurate and might avoid misinterpretation if this was a production query.
This challenge also created a challenge for me, a SQL guy. I am used to being able to join two tables and use functions and Boolean operators in my "group by" statement. That would have made this much simpler. So I had to find a way to split this group by into multiple steps. I got to what I needed though.
This was my first time using Alteryx. I thought it was a good exercise. Feel free to comment.
Thanks
Josh
Awesome seeing some of the sleeker solutions once I had completed my own! Great reason that I love the weekly challenges.