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 #383: Data Parsing Delight!

kmbassett01
8 - Asteroid

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

kmbassett01
8 - Asteroid

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

TonyAndriani
9 - Comet

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

Spoiler
2023-08-10_16-00-21.png
martinding
13 - Pulsar
Spoiler
383.PNG
Dblkirby
5 - Atom
Spoiler
Picture1.png

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

Tofel
8 - Asteroid
Spoiler
Challenge 383.JPG
Reesetrain2
9 - Comet

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.

Spoiler
Screenshot 2023-08-12 222303.png

AndreeaS
8 - Asteroid
Spoiler
383.png

 

Ray_Pospisil
8 - Asteroid

Alteryx and SQL solution

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

FJSantana
6 - Meteoroid

Here is my solution.

 

 

Spoiler
Challenge_383_Spolier.jpg