Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHello,
This one confused me i must say. I had more records than the answer. Took me a while to realise my today isnt the answers today :(
So many different ways to tackle this one!
I haven't used the Generate Rows tool a lot, so I didn't think about having it just populate the dates, rather than a numeric row ID. So I used a few more tools than necessary, but I got there anyway.
Also, doing it a couple days late, I had to manually set the date (rather than using DateTimeToday()) to get my results to match exactly.
First post and first challenge completed. I am betting there are more efficient ways to accomplish, but I got the correct result with about 20 minutes of fumbling around. Loving the Alteryx.
Actually took me 1 hour...but enjoyed it!
Solution attached...