Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #22: Identify Values to Aggregate

Highlighted
Asteroid
 
Highlighted
Asteroid

For some reason I have always been scared of Regex. This exercise was really fun and I think I'm really liking Regex :)

Highlighted
Alteryx Partner

Getting the tokenise at the start right makes this one fairly straightforward from that point.

 

Spoiler
image.png
Meteor

Oh the nostalgia!

 

Spoiler
Challenge 22.PNG

 

 

 

 

Highlighted
Meteor

My solution...

Highlighted
Asteroid

I did this with just formula's at first but then took the opportunity to get some regexp practice as a secondary method for finding the dollar amount.

Highlighted
Asteroid

posted here by mistake as Challenge 23, actually has same name as 22, and I am obviously easily confused.

Highlighted
Asteroid
 
Highlighted
Alteryx Certified Partner

Nice challenge.

 

I sometimes uses that Easter Egg to play a prank on my colleagues if they have walked away from their workflow, and not locked their screens.... priceless 😂

 

Spoiler
Sweet and simple, but I must admit that I gave up on RegEx on this one, and went back to old school String Replacement, since we where going old school 😂

I like the new icons better!I like the new icons better!

 

On my way to Lhotse Face

/Verakso

Highlighted
Fireball

Gotta love a bit of Regex

 

Spoiler
Challenge 22.PNG