<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2020.1">
<Nodes>
<Node ToolID="17">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="498" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>User Details</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="12">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="270" width="84" height="180" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Initial State</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="1">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
<Position x="66" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<NumRows value="10" />
<Fields>
<Field name="Field1" />
</Fields>
<Data>
<r>
<c>Bob|1128|5847 Union St|Arvada|80004</c>
</r>
<r>
<c>Lou|2911|2751 Wolff St|Denver|80212</c>
</r>
<r>
<c>Jack|787|915 S Lima St|Aurora|80012</c>
</r>
<r>
<c>Drew|483|12801 E Kansas Pl|Aurora|80012</c>
</r>
<r>
<c>Nancy|466|2721 S Truckee St|Aurora|80013</c>
</r>
<r>
<c>Patrice|2|376 S Jasmine St|Denver|80224</c>
</r>
<r>
<c>Zara|252|1177 Sequerra St|Broomfield|80020</c>
</r>
<r>
<c>Sherry|3310|15935 E Bethany Pl|Aurora|80013</c>
</r>
<r>
<c>Ralph|960|4851 S Genoa St|Centennial|80015</c>
</r>
<r>
<c>Hudson|1319|5595 S Kenton Way|Englewood|80111</c>
</r>
</Data>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
</Node>
<Node ToolID="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 2</Text>
<Font name="Montserrat ExtraBold" size="21.75" style="1" />
<TextColor name="White" />
<FillColor r="13" g="35" b="69" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="10">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Combine both sets of Customer Transactions,
then combine those entries with the
User Details information.</Text>
<Font name="Montserrat" size="11.25" style="0" />
<TextColor name="White" />
<FillColor r="13" g="35" b="69" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="11">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="186" width="408" height="48" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Combine the Customer Transaction data in "Start 2.1" and "Start 2.2" and ensure there are no duplicate users. Then combine those results with the "User Details". The "User Details" information is delimited by pipes, |. (ctrl + \).</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="3" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="13">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="594" y="270" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Final State</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<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="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="606" y="294" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Final State - Exercise 2.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Final State - Exercise 2.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="5" source="TextInput:" type="V_String" />
<Field name="Store_Number" size="3" source="TextInput:" type="V_String" />
<Field name="Customer_Segment" size="14" source="TextInput:" type="V_String" />
<Field name="Region" size="5" source="TextInput:" type="V_String" />
<Field name="Annual Transactions" source="TextInput:" type="Int16" />
<Field description="TextToColumns: Parsed from Field1" name="Name" size="45" source="TextToColumns: Parsed from Field1" type="V_String" />
<Field description="TextToColumns: Parsed from Field1" name="Address" size="45" source="TextToColumns: Parsed from Field1" type="V_String" />
<Field description="TextToColumns: Parsed from Field1" name="City" size="45" source="TextToColumns: Parsed from Field1" type="V_String" />
<Field description="TextToColumns: Parsed from Field1" name="Zip" size="45" source="TextToColumns: Parsed from Field1" type="V_String" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="18">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="66" y="306" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Start 2.1.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 2.1.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="5" source="TextInput:" type="V_String" />
<Field name="Store_Number" size="3" source="TextInput:" type="V_String" />
<Field name="Customer_Segment" size="14" source="TextInput:" type="V_String" />
<Field name="Region" size="5" source="TextInput:" type="V_String" />
<Field name="Annual Transactions" source="TextInput:" type="Int16" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="19">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="66" y="378" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Start 2.2.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 2.2.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="5" source="TextInput:" type="V_String" />
<Field name="Store_Number" size="3" source="TextInput:" type="V_String" />
<Field name="Customer_Segment" size="14" source="TextInput:" type="V_String" />
<Field name="Region" size="5" source="TextInput:" type="V_String" />
<Field name="Annual Transactions" source="TextInput:" type="Int16" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="20">
<GuiSettings Plugin="AlteryxBasePluginsGui.Union.Union">
<Position x="198" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<ByName_ErrorMode>Warning</ByName_ErrorMode>
<ByName_OutputMode>All</ByName_OutputMode>
<Mode>ByName</Mode>
<SetOutputOrder value="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnion" />
</Node>
<Node ToolID="22">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">
<Position x="210" 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="23">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="474" y="426" />
</GuiSettings>
<Properties>
<Configuration joinByRecordPos="True">
<SelectConfiguration>
<Configuration outputConnection="Join">
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Right_Field1" selected="False" input="Right_" />
<SelectField field="Right_1" selected="True" rename="Name" input="Right_" />
<SelectField field="Right_2" selected="False" input="Right_" />
<SelectField field="Right_3" selected="True" rename="Address" 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="True" />
</SelectFields>
</Configuration>
</SelectConfiguration>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
</Node>
<Node ToolID="26">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="558" y="426" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>6</N>
<GroupFields orderChanged="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 6</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="22" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="18" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="19" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="20" Connection="Output" />
<Destination ToolID="23" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Output" />
<Destination ToolID="23" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="23" Connection="Join" />
<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</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>
