Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #2: Preparing Delimited Data

CarolynR
8 - Asteroid
Spoiler
CarolynR_0-1674160634125.png

 

kaiserj
8 - Asteroid

solved

Edyta_KK
5 - Atom

Solved

diptisingh
6 - Meteoroid

Completed

Dani_Lin
8 - Asteroid

<?xml version="1.0"?>

<AlteryxDocument yxmdVer="2021.4">

  <Nodes>

    <Node ToolID="15">

      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">

        <Position x="60" y="222" width="216" height="156" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <Text>Input</Text>

          <Font name="Lato" 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="455" y="222" width="216" height="156" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <Text>Output</Text>

          <Font name="Lato" 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="70" width="300" height="40" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <Text>Weekly Challenge #2</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="96" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <Text><![CDATA[Many products will export textual data with delimiters such as quotes.  This is done so that strings can contain delimiters or control characters within them.   Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.

 

Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output

]]></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="32">

      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">

        <Position x="90" y="270" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <NumRows value="2" />

          <Fields>

            <Field name="Field_1" />

          </Fields>

          <Data>

            <r>

              <c>"Mary had a little lamb whose fleece was white as snow",123,'16-JUN-01'</c>

            </r>

            <r>

              <c>"I do not like green eggs and ham",456,'25-DEC-10'</c>

            </r>

          </Data>

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText />

          <Left value="False" />

        </Annotation>

      </Properties>

      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />

    </Node>

    <Node ToolID="33">

      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">

        <Position x="186" y="270" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <TempFile>C:\Users\i544314\AppData\Local\Temp\4\Engine_44316_2d76443067a849dbb44d721d27e350d0_\Engine_12340_0490c32a7d544b968af48bd944028d5c_.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="34">

      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">

        <Position x="480" y="270" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <NumRows value="2" />

          <Fields>

            <Field name="Poem" />

            <Field name="Poem_ID" />

            <Field name="Poem_Read_Date" />

          </Fields>

          <Data>

            <r>

              <c>Mary had a little lamb whose fleece was white as snow</c>

              <c>123</c>

              <c>2001-06-16</c>

            </r>

            <r>

              <c>I do not like green eggs and ham</c>

              <c>456</c>

              <c>2010-12-25</c>

            </r>

          </Data>

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText />

          <Left value="False" />

        </Annotation>

      </Properties>

      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />

    </Node>

    <Node ToolID="35">

      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">

        <Position x="588" y="270" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <TempFile>C:\Users\i544314\AppData\Local\Temp\4\Engine_44316_2d76443067a849dbb44d721d27e350d0_\Engine_12340_fdc7635eff6b44608307d4877694484d_.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="36">

      <GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">

        <Position x="174" y="378" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <Field>Field_1</Field>

          <ErrorHandling>Last</ErrorHandling>

          <RootName>

          </RootName>

          <Delimeters value="," />

          <NumFields value="3" />

          <Flags value="0" />

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText />

          <Left value="False" />

        </Annotation>

      </Properties>

      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextToColumns" />

    </Node>

    <Node ToolID="38">

      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">

        <Position x="438" y="378" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <OrderChanged value="False" />

          <CommaDecimal value="False" />

          <SelectFields>

            <SelectField field="Field_1" selected="False" />

            <SelectField field="1" selected="True" rename="Poem" />

            <SelectField field="2" selected="True" rename="Poem_ID" type="Int32" size="4" />

            <SelectField field="3" selected="False" type="Date" size="10" />

            <SelectField field="DateTime_Out" selected="True" rename="Poem_Read_Date" />

            <SelectField field="*Unknown" selected="True" />

          </SelectFields>

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText />

          <Left value="False" />

        </Annotation>

      </Properties>

      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />

    </Node>

    <Node ToolID="39">

      <GuiSettings Plugin="AlteryxBasePluginsGui.DateTime.DateTime">

        <Position x="246" y="378" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <IsFrom value="False" />

          <InputFieldName>3</InputFieldName>

          <Language>English</Language>

          <Format>'dd-Mon-yy'</Format>

          <OutputFieldName>DateTime_Out</OutputFieldName>

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText>Convert 3 From:

Custom</DefaultAnnotationText>

          <Left value="False" />

        </Annotation>

      </Properties>

      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDateTime" />

    </Node>

    <Node ToolID="40">

      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">

        <Position x="534" y="378" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <TempFile>C:\Users\i544314\AppData\Local\Temp\4\Engine_44316_2d76443067a849dbb44d721d27e350d0_\Engine_12340_07ec530ddc54409ebcebfbdcc7d46e01_.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="41">

      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">

        <Position x="342" y="378" />

      </GuiSettings>

      <Properties>

        <Configuration>

          <FormulaFields>

            <FormulaField expression="ReplaceChar([1], '&quot;', &quot;&quot;)" field="1" size="71" type="V_String" />

          </FormulaFields>

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText><![CDATA[1 = ReplaceChar([1], '"', "")

]]></DefaultAnnotationText>

          <Left value="False" />

        </Annotation>

      </Properties>

      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />

    </Node>

  </Nodes>

  <Connections>

    <Connection>

      <Origin ToolID="32" Connection="Output" />

      <Destination ToolID="33" Connection="Input" />

    </Connection>

    <Connection>

      <Origin ToolID="32" Connection="Output" />

      <Destination ToolID="36" Connection="Input" />

    </Connection>

    <Connection>

      <Origin ToolID="34" Connection="Output" />

      <Destination ToolID="35" Connection="Input" />

    </Connection>

    <Connection>

      <Origin ToolID="36" Connection="Output" />

      <Destination ToolID="39" Connection="Input" />

    </Connection>

    <Connection>

      <Origin ToolID="38" Connection="Output" />

      <Destination ToolID="40" Connection="Input" />

    </Connection>

    <Connection>

      <Origin ToolID="39" Connection="Output" />

      <Destination ToolID="41" Connection="Input" />

    </Connection>

    <Connection>

      <Origin ToolID="41" Connection="Output" />

      <Destination ToolID="38" 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" />

    <PredictiveToolsCodePage value="1252" />

    <DisableAllOutput value="False" />

    <ShowAllMacroMessages value="False" />

    <ShowConnectionStatusIsOn value="True" />

    <ShowConnectionStatusOnlyWhenRunning value="True" />

    <ZoomLevel value="0" />

    <LayoutType>Horizontal</LayoutType>

    <MetaInfo>

      <NameIsFileName value="True" />

      <Name>challenge_2_Danielle Linares</Name>

      <Description />

      <RootToolName />

      <ToolVersion />

      <ToolInDb value="False" />

      <CategoryName />

      <SearchTags />

      <Author />

      <Company />

      <Copyright />

      <DescriptionLink actual="" displayed="" />

      <Example>

        <Description />

       <File />

      </Example>

      <WorkflowId value="44423ec4-8145-46c4-8709-55803813ea6f" />

      <Telemetry>

        <PreviousWorkflowId value="52d29329-cfbb-4324-9021-76a24bcba11a" />

        <OriginWorkflowId value="52d29329-cfbb-4324-9021-76a24bcba11a" />

      </Telemetry>

    </MetaInfo>

    <Events>

      <Enabled value="True" />

    </Events>

  </Properties>

</AlteryxDocument>

Raj
16 - Nebula

My sol

Raj_0-1674543308959.png

 

Inactive User
Not applicable

Solution attached

beussew
5 - Atom

Completed tho I got there in a different manner than the posted solution.

SubhaSureshKumar
7 - Meteor
Spoiler
SubhaSureshKumar_0-1674668586382.png

 

Dani_Lin
8 - Asteroid

My solution

 

Dani_Lin_0-1674669325627.png