cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

## Challenge #126: Fill in the [Date] Gaps

Asteroid

Hello,

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 :(

Spoiler
Alteryx Certified Partner
Spoiler

So many different ways to tackle this one!

Pulsar

Little late to the party.  6 tools!

Spoiler
Meteor

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.

Spoiler

Highlighted
Alteryx Partner

And here is my solution, JIT!!

Alteryx Certified Partner

Pretty similar to the rest.

Great little puzzle, I even can spot the day I passed ;)

Spoiler
Alteryx Partner

My Solution! Not pretty but it works :)

Asteroid

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.

Spoiler
Accomplished with Unique (for countries), Formulas (max Date), Generate Rows (to pad dates), Append, Two Sorts, Select, Join, Union, and a Running Total.  Added a summary to compare my work to the desired output.  Tough challenge, but fun.

Meteor
Spoiler

Actually took me 1 hour...but enjoyed it!

Alteryx Certified Partner

Solution attached...

Spoiler
WorkflowRunning total of exams passed