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

Challenge #209: Parsing Insurance Claims

SmitaLohande
9 - Comet

Solution!

igminto
8 - Asteroid

Here's my solution 

mgaronson
11 - Bolide
Spoiler
Challenge 209 Workflow Pic.png

 Tried to parse out headers on the first go around. Gave up and just parsed the data and added the headers.

jdminton
12 - Quasar
Spoiler
 

I went way too far before noticing that the headers included in the report in no way resemble those in the output! Anyway, here is my successful mess. 



Snag_568f948.png

 

steven_quehan
7 - Meteor

Solved

barrymoe
7 - Meteor

Really cool way to work on parsing!

OzlemSigbeku
8 - Asteroid
Spoiler
209.png

Love a bit of regex!

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

Always love a parsing challenge! I used some nice tricks in here.

 

Process:

1) view data row-wise

2) parse data with some tricks

3) attach inception date back to parsed data

4) aggregate data

5) grab headers from answer using dynamic rename

All the best,
BS

LinkedIN

Bulien
Towers
11 - Bolide

really fun!

Spoiler
Screenshot 2024-08-08 152612.png

RasmusFormo
8 - Asteroid
Spoiler
209.png