Challenge #23: Parsing CPG Data

[hbraunius]

My solution is attached.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[nnilz]

Solution attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[DavidThorpe]

My solution:

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Ladarthure]

My solution to this challenge

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[nickjastrzebski]

A lot of steps here, but it's a very common use case so excellent practice!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[bkclaw113]

 This was a fun one once I got beyond the start file being labeled week 22.  Looking forward to see how some other people did this as I imagine there are a number of way to get to the result.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[mceleavey]

Well, this baked my noodle more than it should have. Got there eventually:

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Verakso]

This was fun, and one of the things Alteryx is really good at

Here is my take

Spoiler

Still on my way to Lhotse Face

/Verakso

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[cgoodman3]

Probably not the neatest way to deal with nested headers, but such a good challenge is this is a common problem when dealing with Excel files and needing to turn the data into a table.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[TimothyManning]

Spoiler

Very common problem so it was a good exercise

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.