We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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

aclaxton
8 - Asteroid

Similar to others

Spoiler
Week 22.png
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

kcgreen
8 - Asteroid

Regex to the rescue!

 

 

Spoiler

 

Regex: (?:.*?atm2\.)(.+?)(?:\]|\z)

 

The rows without a closing bracket behind the dollar amount tripped me up for a bit.

 

 

challenge22.JPG

 

CHarrison
8 - Asteroid

Loving the retro icon tip!

 

Here's my solution :) 

asabau
8 - Asteroid

I didn't use the old icons, but here is the solution.

KatieA
Alteryx Alumni (Retired)

Solution attached.

maxjohnson02
8 - Asteroid

Solution attached

kelly_gilbert
13 - Pulsar
 
ponraj
13 - Pulsar

Here is my version of solution

ivoller
12 - Quasar

I used the sledgehammer approach

 

Spoiler
2018-04-16_14-16-07.png