Weekly Challenge

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

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

Submit Feedback
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.

Challenge #207: Parsing Video Game Data

Highlighted
Alteryx
Alteryx

A solution to last week's challenge can be found here.GIPHYGIPHY

 

Video games have become a ubiquitous part of culture over the past few decades. What started as giant consoles became miniaturized for use at home. As popularity increased and technology advanced, more titles were offered by various companies. Whether you wanted to be a frog hopping across the street, stack odd shapes falling from the sky, or defeat the dreaded space invaders, there was a game for you. 

 

Over time, many companies innovated with different categories of games which expanded or create new genres. These games were made available for a variety of platforms - the hardware running the games. 

 

This week's challenge is to parse the provided video game dataset into columns.

Highlighted
Alteryx Certified Partner

Regex to the rescue....again. Solution attached.

 

Spoiler
WorkflowWorkflow

 

And with three tools

Spoiler
Annotation 2020-03-16 152550.jpg
Where the regex used is,
(\d+)(.*) (\w+) \((\d+)\) CAT:(.*) PUB:(.*) \$(\S+)million, \$(\S+)million, \$(\S+)million, \$(\S+)million, \$(\S+)million
Highlighted
Alteryx Certified Partner

I'm not going to pretend that this is pretty... or efficient... but it works! 

 

 

Spoiler
207.png

I don't play video games like I used to but this has made me nostalgic for some Mario Kart 64! 

 

 

 

Highlighted
Alteryx Partner

Some tricky regex in here. These challenges are excellent practice for regular expressions.

 

I posted a video of my solution here: https://youtu.be/I80eCfDph2Y

 

Spoiler
Capture.PNG

 

206] I Can Alteryx That: Hotel Reservations In this edition of I Can Alteryx That, we walk you through a solution to Alteryx weekly challenge #9. View the c...
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Managed to solve without RegEx ...

 

Spoiler
207.png
Highlighted
Alteryx Certified Partner

Great RegEx practice for this challenge:

Spoiler
207.PNG

 (edit 3/16 12:20 CDT) Video of solution overview:

Spoiler
Highlighted
5 - Atom

Used Regex and tried to use minimal number of components

Highlighted
11 - Bolide

Solution attached.

Highlighted
Alteryx
Alteryx

Solution attached.

 

Attempted to use only 1 RegEx tool to parse a significant amount of the data.

Highlighted
15 - Aurora
15 - Aurora
Spoiler
patrick_digan_0-1584380325746.png