Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #23: Parsing CPG Data

KaneG
Alteryx Alumni (Retired)

The key thing that I do with this type of data every time is separate the data from the headers and deal with them separately.

 


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

CapriceW
8 - Asteroid

Here goes!


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

AlexCox
8 - Asteroid

My solution. It works, but I don't like that my solution isn't very dynamic.


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

ipeng
8 - Asteroid

This is an interesting one!


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

AndrewLehm
8 - Asteroid

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

JoeS
Alteryx Alumni (Retired)

Managed to keep it fairly simple, and dynamic other than a couple field names (Week and brand, which will hopefully never change)

Workflow.png

 


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

JamesMA
Alteryx Alumni (Retired)

Found this challenge very difficult, my solution is sadly not dynamic. It did the job on this occasion though.


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

KeithTroutt
8 - Asteroid

This was tough.  My approach seemed to take too many tools but it seems like most solutions did. 

 


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

KeithTroutt
8 - Asteroid

This was tough.  My approach seemed to take too many tools but it seems like most solutions did. 

 


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

rfergus
8 - Asteroid

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