Challenge #31: Alteryx '16 Grand Prix (Race 2, L1)

[TonyA]

Took a couple of extra steps 

Spoiler

because I didn't notice the sites were in the same order in both files.

[nakamott]

My Solution. Wish there was a fuzzy join tool!

[Cory_Snook]

Spoiler

[catherineduffy]

Solution attached

[rachelgatto]

Solved. 

[Shifty]

8 mins!  I whizzed through this one.

Spoiler

For the characteristics, I used a sample to skip the first two rows, then a dynamic rename to get the headers in, binned off the nulls at the bottom of the page (probably didn't need to), filtered on beginner and off to the join. 
For the locations, I used a text to columns to split the site field, cleansed the data of trailing and leading white space, filtered for summer sites and off to the join. 

[nnilz]

Solution attached

[jdemeaux]

Thanks for the dataset! Brought back great memories! :)

[mceleavey]

I think mine is probably the same as everyone else. Nice and simple:

Spoiler

I skipped the first two records and dynamically re-named from the first row of data. I then split the locations on "-" and removed the whitespace. Joined on location and filtered those locations that were suitable for beginners and were in the summer season. Simple.

03:59! Working rapidly there... 

[bkclaw113]

I used Find and Replace as the Join tool since it allows for join on partial text matches which is perfect for this exercise.