We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #316: Blowing in the Wind - Part 1

dmason02
7 - Meteor
Spoiler
dmason02_5-1650976574854.png

 


the answer my friend, is blowing in the wind
the answer is blowing in the wind

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1650918698979.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Smashed it.

 

Spoiler
PhilipMannering_0-1650921377364.png

 

LiuZhang
9 - Comet
Spoiler
316.png
Reesetrain2
9 - Comet

All,

 

If you do not like custom code, you will love this, if not, then not so much...

Spoiler
Capture.PNG

Lets see here:
9 Filter tools
8 Select tools
7Formula Tools
3 Summations
2 Sorts
1 Join
1 Regex &1 text to Column
-This challenge was interesting as the hardest part was the fact that the location had 6 different patterns/combinations as once you got opast that the parsing wasn't that bad. I used a cascade method where I kept using the filter to give me different sets with the same pattern so that I could label them and then I sued a union to bring them back together and a multi-row tool to add back in the county.
-Cheers!
Matt

daniel_lcp
7 - Meteor

done thx

Qiu
20 - Arcturus
20 - Arcturus

Can not imagine the speed for above 100MPH...

Spoiler
Challenge_316.PNG
kelvin_law1
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_0-1650956750948.png

 

josh_dykstra
8 - Asteroid

done

dYoast
11 - Bolide

I think my parsing could be done better.  I will see what others did.

Spoiler
dYoast_0-1650975427702.png