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