Challenge #209: Parsing Insurance Claims

[cc000072]

Here is my solution, it was difficult for me.

Spoiler

[FlorianC]

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

Workflow

[bmcclelland46]

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.

[echen]

My solution attached

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

[JoshuaGostick]

My solution

Spoiler

[Mengdee]

phwoa! really really tough! enjoyed! thanks!

[BlazB]

10 steps but with hard-coded column headers..

Spoiler

[AlexC2]

attached

[paulldjones]

My solution

[EstherB47]

Spoiler

Practicing my tokenizing method in RegEx parsing.....