Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

OldDogNewTricks
10 - Fireball

I was able to use RegEx/Tokenize with great effect for this challenge.

 

Spoiler
challenge_22_completedScreen.jpg
danrh
13 - Pulsar
 
Ukashi
8 - Asteroid

Well that wash good challenge :) a bit tricky (or maybe I'm not good enoughh in RegEx :) ) 

Spoiler
image.png

 

danilang
19 - Altair
19 - Altair

The devil is in the details(of the regex)

 

Spoiler
Slight difference from most.  I used a transpose to simplify the Dollar amount formula.  It only has to act on the value column.

solution 22.png

 

Dan

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
So glad we have the new tool designs! Way more intuitive.
22.PNG
Mikkel_D_Karlsen
8 - Asteroid

My Solution

t_ben
6 - Meteoroid

First post/reply to a challenge!

 

 

Spoiler
Capture.PNG
MarMu
8 - Asteroid

 

Cool challenge.

Pretty straight forward solution. First time using the Tokenize function of the RegEx tool. Possible improvement is to enable marked groups of the tokens. 4 tool solution

Very fun Easter Egg!

 

Spoiler
>challenge_22_start_file_MarMu.png
shahjikin
6 - Meteoroid

First time start Alteryx and completed the challenge. 

kat
12 - Quasar

Alteryx has come such a long way! 

 

Spoiler
Challenge #22.PNG