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

Sashikumar
8 - Asteroid

My Solution  😎

Spoiler
ch262.PNG
Morgan_Thomas
8 - Asteroid

Attached is my solution. This was fun and its always good to practice some regex!

Spoiler
Challenge 262 screenshot.png
rcarog
8 - Asteroid

Solution attached.

 

Spoiler
rcarog_0-1617639095628.png

 

Spalders
8 - Asteroid
Spoiler
Spalders_0-1617642763468.png

 

inspired by @PhilipMannering 

echuong1
Alteryx Alumni (Retired)

It might make more sense to append the receipt information to each record 🙂 

 

Spoiler
echuong1_0-1617645889256.png

 

Harshal_S
5 - Atom

Spent a lot of time on getting the column names dynamically but ended up hardcoding it. Excited to see submissions from others.

 

Spoiler
Harshal_S_0-1617650437485.png

 

cchandler21
Alteryx Alumni (Retired)

here is my solution!

jackf
7 - Meteor

Attached is my solution

mike_w
8 - Asteroid

wow, some serious Regex going on here! 

Spoiler
mike_w_0-1617661720234.png

 

TonyA
Alteryx Alumni (Retired)

This one was fun. Hard to make it truly dynamic, but I tried to make the hard-coded parts relatively simple to change. Also tried to keep the REGEX to a minimum just how much I could do without it. Managed to limit it to two simple REGEXReplace formulas.

Spoiler
Figuring out the field labels was the hardest part, had to look at all three lines character by character to align them properly. 

2021-04-05_17-20-44.png