Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #209: Parsing Insurance Claims

Highlighted
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: GIPHYSource: GIPHY

 

This week's challenge comes from @Assaf_m - thank you for your contribution! We love when our users submit challenges that they've solved on the job!

 

The Input Data is a claims experience record for a group health insurance policy for 3 underwriting years. The data was converted from a PDF file - each page of the PDF is contained in a single cell of data.

 

Your goal is to extract the amounts shown next to each Accident Month (in the block of text under Period) and summarize them with regards to the Inception Date of the policy.

Highlighted
Alteryx Certified Partner

This challenge will "insure" you have a great Monday morning!

Spoiler
209.PNG

(edit 3/30 10:58 CDT) Video of solution overview:

Spoiler
Highlighted
Alteryx Partner

Not an elegant solution at all, but at least it matches the target output.

https://youtu.be/bX7yXX0v_b8

 

Spoiler
I had trouble with the header rows, so I hardcoded the header values. Everything else is dynamic.

Capture.PNG

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Capture.png

Highlighted
Alteryx Certified Partner

Fun warm up for the week! 

 

Spoiler
209.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution below,

 

Spoiler
woofwoof
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Managed to get it down to 12 tools for the table...however i have currently hard coded column headers. Going to keep working on this one!

 

Spoiler
challenge 209 JMS solution.PNG
Highlighted
7 - Meteor

Nice Challenge

Spoiler
Spoiler 

MOHAMMEDAFZAL_0-1585584197694.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

12 tools originally, now down to 8 tools...happy with that!

 

Spoiler
challenge 209 JMS solution v2.PNG
Highlighted
12 - Quasar
12 - Quasar

RegEx rinse Repeat....