Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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