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
8 - Asteroid

Here is my solution, it was difficult for me.

Spoiler
WeeklyChallenge_Ryohei_209.JPG
Highlighted
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
Solutions Engineer
Alteryx
Highlighted
8 - Asteroid

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.

Highlighted
7 - Meteor

My solution attached

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

Highlighted
Alteryx Certified Partner

My solution

 

Spoiler
challenge_209.PNG
Highlighted
8 - Asteroid

phwoa! really really tough! enjoyed! thanks!

 

 

Highlighted
6 - Meteoroid

10 steps but with hard-coded column headers..

 

Spoiler
Spoiler.PNG
Highlighted
8 - Asteroid

attached

Highlighted
5 - Atom

My solution

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Practicing my tokenizing method in RegEx parsing.....

EstherB47_0-1592351734747.png



EstherB47_1-1592351761534.png