Challenge #23: Parsing CPG Data

[DanielMS]

Spoiler

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

[jagdeep_singh85]

PFA my solutino

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

[fmeo]

Spoiler

[hanykowska]

Nice one, my solution below

Spoiler

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

[David-Carnes]

My solution is ugly but done. 

Spoiler

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

[Tom_Luthi]

solution attachment

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

[DavidW]

Spoiler

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

[RWvanLeeuwen]

The only difference I have is the field names, so I probably should have performed some transpose/crosstab-like action in order to produce the same field names, but I think my solution is relatively easy to understand.

Spoiler

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

[FRANCK_ROUQUETTE]

Thank you for the exercise - Please find attached my proposed solution

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

[chetty]

My solution attached

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