We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #316: Blowing in the Wind - Part 1

usmanghayoor
8 - Asteroid

 

Spoiler
usmanghayoor_0-1651126671097.png

I can share the solution if required!

 

Shifty
12 - Quasar

Why use 3 tools when you can use 13?  🤩

 

Shifty_1-1651138839432.png

 

Shifty_0-1651138833957.png

 

dbrownsc
7 - Meteor

Done!

acctbadger96
6 - Meteoroid

Hey there! For the second parse tool you used, how did you determine the number of characters necessary for each group?

 

Thanks and nice job!

Watermark
8 - Asteroid

Decided to go ahead and create Geo Spatial points since I'm betting PART II might need them. 

 

Spoiler
MT Solution 316.jpg

mestevez
8 - Asteroid

This was a fun data parsing challenge

Spoiler
REGEX_Replace([Field_1], "\s+ ", ";") from @dmason02 was key to get the cleanse right.
spolier 3.JPG
mestevez
8 - Asteroid

@acctbadger96 I've used REGEX_Replace([Field_1], "\s+ ", ";") . I suspect this is what you're looking for.

TonyK
8 - Asteroid

my solution

JarekSkudrzyk
11 - Bolide

My solution attached below:)

Ncajamarca
8 - Asteroid

Here is my solution :D

Spoiler
Ncajamarca_0-1651447483417.png