challenge_31_atcodedog05_Solution.yxmd

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2020.1">
  <Nodes>
    <Node ToolID="15">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="59" y="258" width="391" height="216" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text>My Solution</Text>
          <Font name="Microsoft Sans Serif" size="7.8" style="0" />
          <TextColor name="Gray" />
          <FillColor name="White" />
          <Shape shape="0" />
          <Justification Justification="4" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="16">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="474" y="258" width="216" height="216" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text>Output</Text>
          <Font name="Microsoft Sans Serif" size="7.8" style="0" />
          <TextColor name="Gray" />
          <FillColor name="White" />
          <Shape shape="0" />
          <Justification Justification="4" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="29">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="54" y="54" width="324" height="72" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text />
          <Font name="Segoe UI" size="8.25" style="0" />
          <TextColor name="Black" />
          <FillColor name="White" />
          <Shape shape="3" />
          <Justification Justification="4" />
          <BG_Image>iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==</BG_Image>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="30">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="450" y="72" width="300" height="40" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text>Weekly Challenge #31</Text>
          <Font name="Lato" size="16.2" style="0" />
          <TextColor name="Gray" />
          <FillColor name="White" />
          <Shape shape="3" />
          <Justification Justification="0" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="31">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="59" y="114" width="612" height="132" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text>With Inspire being held in beautiful San Diego, I'm planning on taking Friday off and trying out some of the world class surfing! Since it is summer, and I'm definitely a novice, I'd like to visit the surf sites in San Diego County that are appropriate for beginners and summer surfing season. Luckily, I found some datasets on the internet that provide this information.

Join the site characteristics to the site location data.

Identify the four locations that are appropriate for a beginner skill level surfing in the summer season.</Text>
          <Font name="Lato" size="7.8" style="0" />
          <TextColor name="Gray" />
          <FillColor name="White" />
          <Shape shape="0" />
          <Justification Justification="0" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="169">
      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
        <Position x="78" y="282" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <NumRows value="23" />
          <Fields>
            <Field name="Field_1" />
            <Field name="Field_2" />
            <Field name="Field_3" />
            <Field name="Field_4" />
            <Field name="Field_5" />
            <Field name="Field_6" />
          </Fields>
          <Data>
            <r>
              <c>Data Downloaded on June 6, 2016</c>
              <c />
              <c />
              <c />
              <c />
              <c />
            </r>
            <r>
              <c>********************************************</c>
              <c />
              <c />
              <c />
              <c />
              <c />
            </r>
            <r>
              <c>Surf Site</c>
              <c>Swell Direction</c>
              <c>Tide</c>
              <c>Wind Direction</c>
              <c>Boards</c>
              <c>Skill Level</c>
            </r>
            <r>
              <c>Oceanside Beach (North Jetty And Pier)</c>
              <c>South-Southwest, Southwest, West, West-Northwest</c>
              <c>Medium</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced</c>
            </r>
            <r>
              <c>Tamarack St.</c>
              <c>West-Northwest, West, Southwest, South-Southwest</c>
              <c>Low to Medium</c>
              <c>East, Northeast</c>
              <c>Shortboard, longboard, Paddleboard</c>
              <c>Beginner, Intermediate, Advanced</c>
            </r>
            <r>
              <c>Ponto</c>
              <c>West, Northwest, Southwest</c>
              <c>Low to Medium</c>
              <c>East</c>
              <c>Shortboard</c>
              <c>Intermediate, Advanced</c>
            </r>
            <r>
              <c>Swami’s</c>
              <c>Northwest and West</c>
              <c>Low to Medium</c>
              <c>East</c>
              <c>Shortboard, longboard, gun</c>
              <c>Intermediate, Advanced, Expert</c>
            </r>
            <r>
              <c>San Elijo (Pipes)</c>
              <c>Northwest, West</c>
              <c>Low</c>
              <c>East</c>
              <c>Paddleboard</c>
              <c>Intermediate</c>
            </r>
            <r>
              <c>Cardiff Reef And Suckouts</c>
              <c>Northwest, West</c>
              <c>Low to Medium</c>
              <c>East</c>
              <c>Longboard</c>
              <c>Beginner</c>
            </r>
            <r>
              <c>Seaside Reef</c>
              <c>West, Northwest</c>
              <c>Low</c>
              <c>East</c>
              <c>Shortboard</c>
              <c>Intermediate, Advanced</c>
            </r>
            <r>
              <c>Del Mar</c>
              <c>West, Northwest, Southwest</c>
              <c>Low</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced, Expert</c>
            </r>
            <r>
              <c>Blacks Beach</c>
              <c>West, Northwest, Southwest</c>
              <c>Low to Medium</c>
              <c>East, Southeast</c>
              <c>Shortboard, gun</c>
              <c>Advanced, Expert</c>
            </r>
            <r>
              <c>Scripps Pier To La Jolla Shores</c>
              <c>West, Northwest, Southwest</c>
              <c>Medium</c>
              <c>East, Southeast, South</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced, Expert</c>
            </r>
            <r>
              <c>Windandsea</c>
              <c>West, Northwest, Southwest</c>
              <c>Medium</c>
              <c>East, Southeast, South</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced, Expert</c>
            </r>
            <r>
              <c>Birdrock</c>
              <c>Northwest, West-Northwest, Southwest, South-Southwest, West</c>
              <c>Medium to High</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Intermediate, Advanced</c>
            </r>
            <r>
              <c>Pacific Beach (PB Point)</c>
              <c>West, Northwest, Southwest</c>
              <c>Medium to High</c>
              <c>East</c>
              <c>Shortboard, longboard, Paddleboard</c>
              <c>Beginner, Intermediate, Advanced, Expert</c>
            </r>
            <r>
              <c>The Wave House (Bruticus Maximus)</c>
              <c>West, Northwest, Southwest</c>
              <c>Medium to High</c>
              <c>Southeast, East, Northeast</c>
              <c>Paddleboard</c>
              <c>Expert</c>
            </r>
            <r>
              <c>North Mission Beach And South Mission Beach Jetty</c>
              <c>West, Northwest, Southwest</c>
              <c>Medium</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced</c>
            </r>
            <r>
              <c>Ocean Beach</c>
              <c>West, Northwest, Southwest</c>
              <c>Medium</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced</c>
            </r>
            <r>
              <c>Sunset Cliffs</c>
              <c>West, Northwest</c>
              <c>Low</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Intermediate, Advanced</c>
            </r>
            <r>
              <c>Imperial Beach</c>
              <c>West, Northwest, Southwest, South</c>
              <c>Medium</c>
              <c>East, Northwest</c>
              <c>Shortboard</c>
              <c>Beginner, Intermediate, Advanced</c>
            </r>
            <r>
              <c>********************************************</c>
              <c />
              <c />
              <c />
              <c />
              <c />
            </r>
            <r>
              <c>The absolute best source of surf information ever!</c>
              <c />
              <c />
              <c />
              <c />
              <c />
            </r>
          </Data>
        </Configuration>
        <Annotation DisplayMode="1">
          <Name />
          <AnnotationText>Surf Site Characteristics</AnnotationText>
          <DefaultAnnotationText>Surf Site Characteristics</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
    </Node>
    <Node ToolID="170">
      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
        <Position x="78" y="366" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <NumRows value="18" />
          <Fields>
            <Field name="Site" />
            <Field name="Surf Season" />
            <Field name="Location" />
            <Field name="Lat" />
            <Field name="Long" />
          </Fields>
          <Data>
            <r>
              <c>Oceanside Beach (North Jetty And Pier) - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Take I-5 to Mission Avenue, exit at Oceanside, go west to Pacific Street</c>
              <c>33.195065</c>
              <c>-117.385296</c>
            </r>
            <r>
              <c>Tamarack St. - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Take the coastal highway to Tamarack Avenue, to Tamarack State Beach parking lot</c>
              <c>33.152906</c>
              <c>-117.350157</c>
            </r>
            <r>
              <c>Ponto - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Take I-5 to the Pointsetta exit W to 101. Go south past the South Carlsbad Campground.</c>
              <c>33.085267</c>
              <c>-117.312376</c>
            </r>
            <r>
              <c>Swami’s - San Diego County</c>
              <c>Winter</c>
              <c>Take I-5 to Encinitas Boulevard (from the north) or Brimingham (from the south), head west to Highway 1, look for Swami Paramahansa Yogananda’s Fellowship (big gold domes), go down the cliff</c>
              <c>33.034716</c>
              <c>-117.292155</c>
            </r>
            <r>
              <c>San Elijo (Pipes) - San Diego County</c>
              <c>Winter</c>
              <c>Take I-5 to Encinitas Boulevard, turn left to Highway 1, park in the San Elijo State Beach lot</c>
              <c>33.021311</c>
              <c>-117.2851</c>
            </r>
            <r>
              <c>Cardiff Reef And Suckouts - San Diego County</c>
              <c>Winter</c>
              <c>Take Highway 101, accessible from either north or south, or the Manchester exit from the freeway</c>
              <c>33.0096</c>
              <c>-117.279406</c>
            </r>
            <r>
              <c>Seaside Reef - San Diego County</c>
              <c>Winter</c>
              <c>Take Highway 101 south just past Cardiff Reef</c>
              <c>33.001785</c>
              <c>-117.27701</c>
            </r>
            <r>
              <c>Del Mar - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Exit I-5 at Villa de la Valle (from north) or Del Mar Heights Road (from south). Breaks from 15 Street to 20th Street.</c>
              <c>32.98137</c>
              <c>-117.272864</c>
            </r>
            <r>
              <c>Blacks Beach - San Diego County</c>
              <c>Winter</c>
              <c>Park at the Torrey Pines Glider Port. Go down the trail to the beach.</c>
              <c>32.889229</c>
              <c>-117.253684</c>
            </r>
            <r>
              <c>Scripps Pier To La Jolla Shores - San Diego County</c>
              <c>Winter</c>
              <c>Take La Jolla Shores Drive to El Paseo Grande</c>
              <c>32.857656</c>
              <c>-117.257092</c>
            </r>
            <r>
              <c>Windandsea - San Diego County</c>
              <c>Winter</c>
              <c>From La Jolla Boulevard, drive west on Nautilus Street, park along Neptune Street</c>
              <c>32.831135</c>
              <c>-117.281147</c>
            </r>
            <r>
              <c>Birdrock - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Drive down La Jolla Boulevard, go west on Birdrock Street, park and walk down the stairs</c>
              <c>32.814463</c>
              <c>-117.274334</c>
            </r>
            <r>
              <c>Pacific Beach (PB Point) - San Diego County</c>
              <c>Winter</c>
              <c>Between Point Loma and La Jolla. Park at Calumet Avenue and Linda Way.</c>
              <c>32.795353</c>
              <c>-117.256861</c>
            </r>
            <r>
              <c>The Wave House (Bruticus Maximus) - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>3115 Ocean Front Walk, Mission Beach</c>
              <c>32.770784</c>
              <c>-117.25319</c>
            </r>
            <r>
              <c>North Mission Beach And South Mission Beach Jetty - San Diego County</c>
              <c>Spring, Fall, Winter</c>
              <c>Follow Mission Beach to the beach</c>
              <c>32.761195</c>
              <c>-117.253454</c>
            </r>
            <r>
              <c>Ocean Beach - San Diego County</c>
              <c>Fall, Winter, Spring</c>
              <c>At the end of Interstate 8, take I-8 to Sunset Cliffs Boulevard, then a right at Newport Street. Ocean Beach is 3 blocks west.</c>
              <c>32.749329</c>
              <c>-117.252803</c>
            </r>
            <r>
              <c>Sunset Cliffs - San Diego County</c>
              <c>Fall, Winter, Spring</c>
              <c>Take I-5 to Sunset Cliffs Drive, take that to Point Loma, you’ll see Sunset Cliffs Beach</c>
              <c>32.727299</c>
              <c>-117.255851</c>
            </r>
            <r>
              <c>Imperial Beach - San Diego County</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>From I-5, take Palm Avenue to the beach, go south on Seacoast Drive</c>
              <c>32.578289</c>
              <c>-117.132722</c>
            </r>
          </Data>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <AnnotationText>Surf Site Locations</AnnotationText>
          <DefaultAnnotationText>Surf Site Locations</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
    </Node>
    <Node ToolID="171">
      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
        <Position x="510" y="330" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <NumRows value="4" />
          <Fields>
            <Field name="Surf Site" />
            <Field name="Swell Direction" />
            <Field name="Tide" />
            <Field name="Wind Direction" />
            <Field name="Boards" />
            <Field name="Skill Level" />
            <Field name="Surf Season" />
            <Field name="Location" />
            <Field name="Lat" />
            <Field name="Long" />
          </Fields>
          <Data>
            <r>
              <c>Del Mar</c>
              <c>West, Northwest, Southwest</c>
              <c>Low</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced, Expert</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Exit I-5 at Villa de la Valle (from north) or Del Mar Heights Road (from south). Breaks from 15 Street to 20th Street.</c>
              <c>32.98137</c>
              <c>-117.272864</c>
            </r>
            <r>
              <c>Imperial Beach</c>
              <c>West, Northwest, Southwest, South</c>
              <c>Medium</c>
              <c>East, Northwest</c>
              <c>Shortboard</c>
              <c>Beginner, Intermediate, Advanced</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>From I-5, take Palm Avenue to the beach, go south on Seacoast Drive</c>
              <c>32.578289</c>
              <c>-117.132722</c>
            </r>
            <r>
              <c>Oceanside Beach (North Jetty And Pier)</c>
              <c>South-Southwest, Southwest, West, West-Northwest</c>
              <c>Medium</c>
              <c>East</c>
              <c>Shortboard, longboard</c>
              <c>Beginner, Intermediate, Advanced</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Take I-5 to Mission Avenue, exit at Oceanside, go west to Pacific Street</c>
              <c>33.195065</c>
              <c>-117.385296</c>
            </r>
            <r>
              <c>Tamarack St.</c>
              <c>West-Northwest, West, Southwest, South-Southwest</c>
              <c>Low to Medium</c>
              <c>East, Northeast</c>
              <c>Shortboard, longboard, Paddleboard</c>
              <c>Beginner, Intermediate, Advanced</c>
              <c>Spring, Summer, Fall, Winter</c>
              <c>Take the coastal highway to Tamarack Avenue, to Tamarack State Beach parking lot</c>
              <c>33.152906</c>
              <c>-117.350157</c>
            </r>
          </Data>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
    </Node>
    <Node ToolID="174">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="606" y="330" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\Kiran\AppData\Local\Temp\Engine_8048_d90af6c03f0b41dabb7f58dcbe4b515c_\Engine_6736_fb551a03d237409b9489b6ef59919dcc_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Profile</DefaultTab>
              <Hints>
                <Table />
              </Hints>
            </View1>
            <View2 />
          </Layout>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
    </Node>
    <Node ToolID="175">
      <GuiSettings>
        <Position x="138" y="282" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="Ranges">3-21</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings Macro="SelectRecords.yxmc" />
    </Node>
    <Node ToolID="176">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DynamicRename.DynamicRename">
        <Position x="198" y="294" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <RenameMode>FirstRow</RenameMode>
          <Fields orderChanged="False">
            <Field name="Field_1" />
            <Field name="Field_2" />
            <Field name="Field_3" />
            <Field name="Field_4" />
            <Field name="Field_5" />
            <Field name="Field_6" />
            <Field name="*Unknown" />
          </Fields>
          <Expression />
          <FirstRow>
            <OnError>Warn</OnError>
          </FirstRow>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Surf Site" size="50" source="TextInput:" type="V_String" />
            <Field name="Swell Direction" size="59" source="TextInput:" type="V_String" />
            <Field name="Tide" size="14" source="TextInput:" type="V_String" />
            <Field name="Wind Direction" size="26" source="TextInput:" type="V_String" />
            <Field name="Boards" size="34" source="TextInput:" type="V_String" />
            <Field name="Skill Level" size="40" source="TextInput:" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDynamicRename" />
    </Node>
    <Node ToolID="177">
      <GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">
        <Position x="138" y="366" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Field>Site</Field>
          <ErrorHandling>Last</ErrorHandling>
          <RootName>Surf Site</RootName>
          <Delimeters value="-" />
          <NumFields value="2" />
          <Flags value="0" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextToColumns" />
    </Node>
    <Node ToolID="178">
      <GuiSettings>
        <Position x="198" y="366" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="List Box (11)">"Site","Surf Season","Location","Lat","Long","Surf Site1","Surf Site2"</Value>
          <Value name="Check Box (84)">True</Value>
          <Value name="Check Box (117)">True</Value>
          <Value name="Check Box (15)">True</Value>
          <Value name="Check Box (109)">False</Value>
          <Value name="Check Box (122)">False</Value>
          <Value name="Check Box (53)">False</Value>
          <Value name="Check Box (58)">False</Value>
          <Value name="Check Box (70)">False</Value>
          <Value name="Check Box (77)">False</Value>
          <Value name="Drop Down (81)">upper</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings Macro="Cleanse.yxmc" />
    </Node>
    <Node ToolID="179">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
        <Position x="258" y="330" />
      </GuiSettings>
      <Properties>
        <Configuration joinByRecordPos="False">
          <JoinInfo connection="Left">
            <Field field="Surf Site" />
          </JoinInfo>
          <JoinInfo connection="Right">
            <Field field="Surf Site1" />
          </JoinInfo>
          <SelectConfiguration>
            <Configuration outputConnection="Join">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="Right_Site" selected="False" input="Right_" />
                <SelectField field="Right_Surf Site2" selected="False" input="Right_" />
                <SelectField field="*Unknown" selected="True" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
    </Node>
    <Node ToolID="180">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="318" y="330" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression><![CDATA[REGEX_Match([Skill Level], "Beginner.*")
and
REGEX_Match([Surf Season], ".*Summer.*")
]]></Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="2">
          <Name />
          <DefaultAnnotationText>REGEX_Match([Skill Level], "Beginner.*")
and
REGEX_Match([Surf Season], ".*Summe...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="181">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="378" y="330" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Layout>
            <View1>
              <Hints>
                <Table />
              </Hints>
            </View1>
          </Layout>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <AnnotationText>Solution</AnnotationText>
          <DefaultAnnotationText>Solution</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
    </Node>
  </Nodes>
  <Connections>
    <Connection>
      <Origin ToolID="169" Connection="Output" />
      <Destination ToolID="175" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="170" Connection="Output" />
      <Destination ToolID="177" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="171" Connection="Output" />
      <Destination ToolID="174" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="175" Connection="Output" />
      <Destination ToolID="176" Connection="Targets" />
    </Connection>
    <Connection>
      <Origin ToolID="176" Connection="Output" />
      <Destination ToolID="179" Connection="Left" />
    </Connection>
    <Connection>
      <Origin ToolID="178" Connection="Output26" />
      <Destination ToolID="179" Connection="Right" />
    </Connection>
    <Connection>
      <Origin ToolID="177" Connection="Output" />
      <Destination ToolID="178" Connection="Input2" />
    </Connection>
    <Connection>
      <Origin ToolID="179" Connection="Join" />
      <Destination ToolID="180" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="180" Connection="True" />
      <Destination ToolID="181" Connection="Input" />
    </Connection>
  </Connections>
  <Properties>
    <Memory default="True" />
    <GlobalRecordLimit value="0" />
    <TempFiles default="True" />
    <Annotation on="True" includeToolName="False" />
    <ConvErrorLimit value="10" />
    <ConvErrorLimit_Stop value="False" />
    <CancelOnError value="False" />
    <DisableBrowse value="False" />
    <EnablePerformanceProfiling value="False" />
    <DisableAllOutput value="False" />
    <ShowAllMacroMessages value="False" />
    <ShowConnectionStatusIsOn value="True" />
    <ShowConnectionStatusOnlyWhenRunning value="True" />
    <ZoomLevel value="0" />
    <LayoutType>Horizontal</LayoutType>
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>challenge_31_atcodedog05_Solution</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
    </MetaInfo>
    <Events>
      <Enabled value="True" />
    </Events>
  </Properties>
</AlteryxDocument>