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

Tgigs
8 - Asteroid

My solution attached.

 

Used a regex expression to tokenize the field into many columns, then transposed the data and parsed with regex expression, and lastly converted the string to double and summarized.

MatthewGrant12
8 - Asteroid

Solution

dkungu
8 - Asteroid

Alteryx UI has come a long way.img - challenge_22.png

JBLove
10 - Fireball

Solution attached.

afnfyz
8 - Asteroid

Once I realized that there were multiple $ values in one row this became pretty straight forward.

Spoiler
Screenshot 2023-10-23 135637.png
nikhilnijhar
8 - Asteroid
Spoiler
Screenshot 2023-10-24 163628.png
AthollJ
8 - Asteroid

Solution attached

RasmusFormo
8 - Asteroid

My solution :)

Carolyn
12 - Quasar
12 - Quasar

Complete! Really fun to see it with the old tool designs

 

Spoiler
2023-11-06_12-54-02.png

CoG
14 - Magnetar

Art change is definitely an upgrade!

Spoiler
Workflow.png