Challenge #126: Fill in the [Date] Gaps

[clant]

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

[ckings]

Spoiler

So many different ways to tackle this one! 

[danrh]

Little late to the party.  6 tools!

Spoiler

[cbrettlockard]

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

 

[datatim]

And here is my solution, JIT!!

[JordyMicheal]

Pretty similar to the rest.

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

Spoiler

[Rachel_B]

My Solution! Not pretty but it works :)

[mpennington]

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.      

[Aster]

Spoiler

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

[PhilipMannering]

Solution attached...

Spoiler

WorkflowRunning total of exams passed