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 #22: Identify Values to Aggregate

treepruner
9 - Comet

It isn't a pretty solution, but it works!

wwatson
12 - Quasar

my solution

mollymargolis
8 - Asteroid

my solution

JethroChen
10 - Fireball
Spoiler
challenge_22_jc.PNG
sumanthskumar
8 - Asteroid

Challenge #52

Spoiler
sumanthskumar_0-1597039240330.png

 

JoePC
9 - Comet

Solution Attached

Qiu
21 - Polaris
21 - Polaris

Not so difficult one.

Spoiler
en-22.PNG
meetpuru
8 - Asteroid

Soln_22

allwynthomas24
11 - Bolide

Challenge 22 Done.

 

Spoiler
Workflow

challenge_22_solution_AllwynThomas_Spoiler.PNG

 



Thanks & Regards,
Allwyn Thomas

KilianL
Alteryx Alumni (Retired)

Learnt something new about RegEx Tokenize: using brackets and the * and ? quantifiers.
This provides a simple solution using only one regex tool to extract the transaction amounts.

I tried three different approaches to solve this challenge, see workflow attached, including an explanation.

 

Spoiler
022 - RegEx Tokenize - Kilian.png

possible RegEx Tokenize expressions:
atm2\.(\d+\.\d+|\d+)
atm2\.(\d+\.*\d*)
atm2\.(\d+\.?\d*)

Kilian Leifeld

Sales Engineer - Alteryx