Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #126: Fill in the [Date] Gaps

paulburrows
8 - Asteroid

My solution - thanks

timrains
8 - Asteroid

Nice 1 like this...

 

Spoiler
Week126.PNG
justindavis
10 - Fireball
Spoiler
challenge_126_solution_justindavis.PNG
dhtay
8 - Asteroid

This was an interesting one. As always, there are aspects of Generate Rows that stump me. Sometimes you just have to prioritise efficiency and plough through the problem with an inelegant solution.

 

By the way, cool gif!

 

challenge126.PNG

ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.JPG
SueDonim
8 - Asteroid

I still need a bit of work on my joins, but they are getting better.

 

Spoiler
Process
- (Lower thread): Text input with start and end dates
- Generate rows: Initialise at Start, then increment by one day (DateTimeAdd) until reach End
- (Upper thread): Summarise countries (group by)
- Append generated dates to country list
- Join with provided data
- Create "passed_exams" field from Right join (initialised at "0")
- Union Join data with Right Join data
- Sort by country and date (this might not be necessary)
- Running total (group by country)
- Sort and cleanup

MySolution.PNG
Assaf_m
11 - Bolide

Solution Attached

tiffany_chen
8 - Asteroid

Fun!

Spoiler
Annotation 2020-01-03 135626.png
ponraj
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
rmassambane
10 - Fireball