Challenge #209: Parsing Insurance Claims

[hbraunius]

My solution attached. I also updated the dates to be in standard date format.

Spoiler

[patrick_digan]

Spoiler

[OllieClarke]

I might have had to parse some pdfs in my time before

Spoiler

Since the table structure was the same, I hard coded the headers for ease of building rather than trying to parse them too

[pasccout]

My solution

[abrouwer]

Attached is my solution

Spoiler

[T_Willins]

My solution.  Thanks @Assaf_m for sharing another real world Alteryx solution!

Spoiler

[grossal]

Spoiler

Such a nice challenge. I thought I could do it with less tools, but 10 Tools shouldn't be too bad.

Alex

[mbogusz]

Spoiler

[Garrett]

Wouldn't it be handy if Alteryx supported reading PDF directly without needing unsupported R or Python code?

[JORGE4900]

Here I am using the Inception date as a row identifier; trimming the field and tokenizing the new lines makes the parsing easier. I still had to clean the commas after parsing in order to change data types.

It is always fun to parse data using REGEX.

Spoiler