Search

Close

Start Free Trial

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

Well that was humbling 😅 - looking forward to learning something as a look at other solutions

haha - I had a lot of failed branches to the delete at the end.

This one was fun. Rarely have a chance to use the JSON tool.

Nice to get the JSON Parse tool off the shelf - it was getting dusty up there.

Challenge 383.JPG

All,

My solution using a Text-to-Column, 2 DateTime, and a formula tool.

-I also assumed that if there were two condition types, that we use the second.

Screenshot 2023-08-12 222303.png

Alteryx and SQL solution

I tried Alteryx also without the JSON tool and it was much more manual

4 KB

Here is my solution.

Live Weekly Challenge