Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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