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.

Matthew
8 - Asteroid

Solution

dkungu
8 - Asteroid

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

DQAUDIT
9 - Comet

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
7 - Meteor

Solution attached

RasmusFormo
8 - Asteroid

My solution :)

Carolyn
8 - Asteroid

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

 

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

AndrewDMerrill
13 - Pulsar

Art change is definitely an upgrade!

Spoiler
Workflow.png