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

Seems to me it makes more sense to keep Bob in the list. If you take him out then if you query for a list of members for any date between 2015-02-20 and 2017-08-07, your list would be incomplete. Also, how do we know from the data that Bob was dropped from the roster -- he might be in the same state Richard was before the updates. His end date was recorded, but his new status hasn't been added yet. Anyway, here's my solution.

My solution attached.

Solution attached.

30-04-2019 08-49-25.png

shouldn't there be an end date for Bob?

my solution attached

My solution

Workflow 80.GIF

Starting the week with a challenge!

Challenge 80 Solution.PNG

Not sure my answer is particularly elegant

Challenge 80.PNG

union old and new, sort, multirow, formula, and use a summarize on the flags with a filter and join to keep only jedi folk

union old and new, sort, multirow, formula, and use a summarize on the flags with a filter and join to keep only jedi folk

curated machine learning resources