Weekly Challenges

kmbassett01 · ‎08-10-2023

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

kmbassett01 · ‎08-10-2023

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

TonyAndriani · ‎08-10-2023

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

martinding · ‎08-10-2023

Dblkirby · ‎08-11-2023

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

Tofel · ‎08-11-2023

Reesetrain2 · ‎08-12-2023

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.

AndreeaS · ‎08-13-2023

Ray_Pospisil · ‎08-13-2023

Alteryx and SQL solution

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

FJSantana · ‎08-13-2023

Here is my solution.

Challenge #383: Data Parsing Delight!