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

cc000072
8 - Asteroid

Here is my solution, it was difficult for me.

Spoiler
WeeklyChallenge_Ryohei_209.JPG
FlorianC
Alteryx
Alteryx

I wanted to parse the headers dynamically but there is no way to do it without setting up some arbitrary rules based on the input data. Indeed, the headers are incredibly badly structured and the input is unreliable as can be seen in the six sample PDF files.

 

If the headers have to evolve eventually, one solution would be to use a text input tool to dynamically rename the columns based on a provided list.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
bmcclelland46
10 - Fireball

Heck of a ride - looks like mine matches up though, although I think my sorting was a little off. Don't think that was the point though so here ya go.

EllenChen
7 - Meteor

My solution attached

Tools used : Regex, Text to Column, Transpose, Multi-Field Formula, Sample, Dynamic Rename

JoshuaGostick
11 - Bolide

My solution

 

Spoiler
challenge_209.PNG
Mengdee
8 - Asteroid

phwoa! really really tough! enjoyed! thanks!

 

 

BlazB
6 - Meteoroid

10 steps but with hard-coded column headers..

 

Spoiler
Spoiler.PNG
AlexC2
8 - Asteroid

attached

paulldjones
6 - Meteoroid

My solution

 

estherb47
15 - Aurora
15 - Aurora
Spoiler
Practicing my tokenizing method in RegEx parsing.....

EstherB47_0-1592351734747.png



EstherB47_1-1592351761534.png