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

mickael_gest
8 - Asteroid

My solution :)

 

 

Spoiler
challenge_22.PNG
arein0
8 - Asteroid
 
kcoulon
8 - Asteroid

Challenge Solved - slightly different approach but same general idea

CaraI
Alteryx
Alteryx

Attached both versions - new and old school tools for comparison

 

Spoiler
Spoiler - 

22 workflow.jpgOld SchoolOld School
justynam
8 - Asteroid

My solution attached

 

I am glad that you have changed the tools to give them the new look :-)

svenk
8 - Asteroid

My Solution!

justin_winter
8 - Asteroid

Got mixed up on the part about summing the parsed amounts, but got it once I realized I had misunderstood it!

Jim7
8 - Asteroid

Cool to learn about converting to the original icons, attached is my solution.

tcroberts
12 - Quasar

Here's my solution:

 

 

Spoiler
WC22workflow.PNG

Really great RegEx practice in this one. I spent a bunch of time trying to do this with an iterative macro before realizing that the Tokenize functionality does exactly what I want when combined with the Transpose Tool.

 

dillon_bok
8 - Asteroid
Spoiler
Challenge_22.PNG