ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Practice Exercise

Learning Path 1: Exercise 2: General

Abi25
5 - Atom

<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnion" />
</Node>
<Node ToolID="21">
<GuiSettings Plugin="AlteryxBasePluginsGui.Unique.Unique">
<Position x="294" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<UniqueFields>
<Field field="Customer_ID" />
</UniqueFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnique" />
</Node>
<Node ToolID="25">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">
<Position x="162" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<Field>Field1</Field>
<ErrorHandling>Last</ErrorHandling>
<RootName>
</RootName>
<Delimeters value="|" />
<NumFields value="5" />
<Flags value="0" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextToColumns" />
</Node>
<Node ToolID="26">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="246" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="1" selected="True" rename="Name" />
<SelectField field="2" selected="True" rename="Customer ID" />
<SelectField field="3" selected="True" />
<SelectField field="4" selected="True" />
<SelectField field="5" selected="True" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
<Node ToolID="27">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="402" y="426" />
</GuiSettings>
<Properties>
<Configuration joinByRecordPos="False">
<JoinInfo connection="Left">
<Field field="Customer_ID" />
</JoinInfo>
<JoinInfo connection="Right">
<Field field="Customer ID" />
</JoinInfo>
<SelectConfiguration>
<Configuration outputConnection="Join">
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Left_Customer_ID" selected="False" input="Left_" />
<SelectField field="Right_Customer ID" selected="True" input="Right_" />
<SelectField field="Left_Store_Number" selected="True" input="Left_" />
<SelectField field="Left_Customer_Segment" selected="True" input="Left_" />
<SelectField field="Left_Region" selected="True" input="Left_" />
<SelectField field="Left_Annual Transactions" selected="True" input="Left_" />
<SelectField field="Right_Name" selected="True" input="Right_" />
<SelectField field="Right_3" selected="True" rename="adress" input="Right_" />
<SelectField field="Right_4" selected="True" rename="city" input="Right_" />
<SelectField field="Right_5" selected="True" rename="zip" input="Right_" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
</SelectConfiguration>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="25" Connection="Input" />
</Connection>
<Connection name="tabla 1 de clientes">
<Origin ToolID="18" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection name="tabla 2 de clientes">
<Origin ToolID="19" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="20" Connection="Output" />
<Destination ToolID="21" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="21" Connection="Unique" />
<Destination ToolID="27" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="26" Connection="Output" />
<Destination ToolID="27" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="25" Connection="Output" />
<Destination ToolID="26" 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>Practice Exercise 2_Alejandro_Fdez</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>

Abi25
5 - Atom

<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnion" />
</Node>
<Node ToolID="21">
<GuiSettings Plugin="AlteryxBasePluginsGui.Unique.Unique">
<Position x="294" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<UniqueFields>
<Field field="Customer_ID" />
</UniqueFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnique" />
</Node>
<Node ToolID="25">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">
<Position x="162" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<Field>Field1</Field>
<ErrorHandling>Last</ErrorHandling>
<RootName>
</RootName>
<Delimeters value="|" />
<NumFields value="5" />
<Flags value="0" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextToColumns" />
</Node>
<Node ToolID="26">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="246" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="1" selected="True" rename="Name" />
<SelectField field="2" selected="True" rename="Customer ID" />
<SelectField field="3" selected="True" />
<SelectField field="4" selected="True" />
<SelectField field="5" selected="True" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
<Node ToolID="27">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="402" y="426" />
</GuiSettings>
<Properties>
<Configuration joinByRecordPos="False">
<JoinInfo connection="Left">
<Field field="Customer_ID" />
</JoinInfo>
<JoinInfo connection="Right">
<Field field="Customer ID" />
</JoinInfo>
<SelectConfiguration>
<Configuration outputConnection="Join">
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Left_Customer_ID" selected="False" input="Left_" />
<SelectField field="Right_Customer ID" selected="True" input="Right_" />
<SelectField field="Left_Store_Number" selected="True" input="Left_" />
<SelectField field="Left_Customer_Segment" selected="True" input="Left_" />
<SelectField field="Left_Region" selected="True" input="Left_" />
<SelectField field="Left_Annual Transactions" selected="True" input="Left_" />
<SelectField field="Right_Name" selected="True" input="Right_" />
<SelectField field="Right_3" selected="True" rename="adress" input="Right_" />
<SelectField field="Right_4" selected="True" rename="city" input="Right_" />
<SelectField field="Right_5" selected="True" rename="zip" input="Right_" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
</SelectConfiguration>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="25" Connection="Input" />
</Connection>
<Connection name="tabla 1 de clientes">
<Origin ToolID="18" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection name="tabla 2 de clientes">
<Origin ToolID="19" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="20" Connection="Output" />
<Destination ToolID="21" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="21" Connection="Unique" />
<Destination ToolID="27" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="26" Connection="Output" />
<Destination ToolID="27" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="25" Connection="Output" />
<Destination ToolID="26" 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>Practice Exercise 2_Alejandro_Fdez</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>

All errors highlighted and all.

mgorlero003
5 - Atom

Exercise 2: General Done. 

abhishekahuja35
7 - Meteor

Practice Exercise 2 Solution

ngedeon32
5 - Atom

Here is my attempt to exercise 2.

akpatel6
5 - Atom

Solution

P117
6 - Meteoroid

My Solution for Practice Exercise 2

joster
5 - Atom

Practice 2 solution

joster
5 - Atom

solution

rohityaman
8 - Asteroid

Done!