Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACompleted
<?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], '"', "")" 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>
My sol
My solution