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

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 #262: With-invoice

nlensing001
7 - Meteor

My solution

AngelosPachis
16 - Nebula

My solution for challenge #262. 

 

Spoiler
AngelosPachis_0-1618158496358.png

 

ulaimins
6 - Meteoroid
Spoiler
Alteryx Challange #262.JPG
JP_SDAK
8 - Asteroid

The hardest part was finding the original post to reply to!  😁  I did this dynamically for headers, but it still seems a little long.  I parsed headers and data separately, maybe I could have combined?

Spoiler
JP_SDAK_0-1618243863439.png

 

randreag
11 - Bolide

here my solution

Ladarthure
14 - Magnetar
14 - Magnetar

Maybe not the easiest and straight forward way to do the job but went with a dynamic regex solution

lewanark
8 - Asteroid

oversimplified solution  without dynamically found headers and/or length of the field, but still fun 🙂

Spoiler
lewanark_0-1618326997920.png

 

phottovy
13 - Pulsar
13 - Pulsar

Props to @PhilipMannering@BeginnerMindset@Luke_C@Harshal_S@TonyA@CatheyH, @OllieClarke, @Maskell_Rascal, @JP_SDAK, @Ladarthure  (apologies to anyone I missed) for attempting to solve this challenge with a dynamic solution! 

 

I enjoyed dynamically calculating a ReGex expression to split based on the number of dashes but could never quite figure out how to use the expression in the RegEx tool. Here is a different approach with an iterative macro.

dsmdavid
11 - Bolide

Kind of dynamic, depending how much invoices change...

Spoiler
dsmdavid_0-1618589215126.png
dsmdavid_1-1618589334819.png

 

 

byagelski
8 - Asteroid

Parstar - I love it.