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 #188: Difficult, but not im-parse-able

nickjastrzebski
8 - Asteroid

Regex saves the day once again!

 

Spoiler
image.png
JennyMartin
9 - Comet
Spoiler
AWC188.PNG

We've all worked with a dataset like this out in the wild 😛

AngelosPachis
16 - Nebula

My solution for challenge #188

 

Spoiler
Screenshot 2020-09-19 122938.png
JethroChen
10 - Fireball
Spoiler
challenge_188_jc.PNG
seinchyiwoo
Alteryx Alumni (Retired)

regex to the rescue:

Spoiler
seinchyiwoo_0-1600923969993.png

 

jamielaird
14 - Magnetar

Here's my solution:

 

Spoiler
jamielaird_0-1602507314981.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1604836431206.png

 

Paradox
7 - Meteor
Spoiler
Paradox_0-1605286858228.png

Carried the VAT number down, then filtered to the header and value rows. Marked delimiters, parsed, then replaced field names with the header row. The rest was formatting with Multi-Column and sorting.

WernerE
8 - Asteroid
Spoiler
Screenshot_1.jpg
JP_SDAK
8 - Asteroid

Good practice for advanced exam - but painful!

Spoiler
JP_SDAK_0-1606936648854.png