<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>
<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.
Practice 2 solution