community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #126: Fill in the [Date] Gaps

Asteroid

My solution - thanks

Asteroid

Nice 1 like this...

 

Spoiler
Week126.PNG
Highlighted
Asteroid
Spoiler
challenge_126_solution_justindavis.PNG
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

Quasar

My solution:

 

Spoiler
Capture.JPG
Alteryx Partner

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
Asteroid

Solution Attached

Asteroid

Fun!

Spoiler
Annotation 2020-01-03 135626.png
Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
Asteroid