Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Practice Exercise

Learning Path 1: Exercise 2: General

20C41A0512
5 - Atom
‎01-03-2023 06:36 PM

h

Practice+Exercise+2.yxzp
Reply
0 Likes
wen_wei_91
6 - Meteoroid
‎01-03-2023 07:49 PM

Completed

Practice Exercise 2_Completed.yxmd
Reply
0 Likes
jainharshokay
5 - Atom
‎01-03-2023 09:35 PM

Wonderful Experience in Practice Exercise 2

Practice 2_solution Harshjain75.yxmd
Reply
0 Likes
Khushimakhija
6 - Meteoroid
‎01-04-2023 12:27 AM

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.2">
<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="21">
<GuiSettings Plugin="AlteryxBasePluginsGui.Union.Union">
<Position x="222" y="306" />
</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="23">
<GuiSettings Plugin="AlteryxBasePluginsGui.Unique.Unique">
<Position x="306" y="306" />
</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="24">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="426" y="306" />
</GuiSettings>
<Properties>
<Configuration joinByRecordPos="False">
<JoinInfo connection="Left">
<Field field="Customer_ID" />
</JoinInfo>
<JoinInfo connection="Right">
<Field field="CustomerID" />
</JoinInfo>
<SelectConfiguration>
<Configuration outputConnection="Join">
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Right_CustomerID" selected="False" 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="25">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">
<Position x="222" 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="318" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Field1" selected="False" />
<SelectField field="1" selected="True" rename="Name" />
<SelectField field="2" selected="True" rename="CustomerID" />
<SelectField field="3" selected="True" rename="Address" />
<SelectField field="4" selected="True" rename="City" />
<SelectField field="5" selected="True" rename="Zip Code" />
<SelectField field="*Unknown" selected="True" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="25" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="18" Connection="Output" />
<Destination ToolID="21" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="19" Connection="Output" />
<Destination ToolID="21" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="21" Connection="Output" />
<Destination ToolID="23" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="23" Connection="Unique" />
<Destination ToolID="24" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="26" Connection="Output" />
<Destination ToolID="24" 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</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>

Reply
0 Likes
Khushimakhija
6 - Meteoroid
‎01-04-2023 12:30 AM

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.3">
<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="282" />
</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="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>

Reply
0 Likes
Priyanshu620
5 - Atom
‎01-04-2023 01:55 AM

second exercise

exr 2.yxmd
Reply
0 Likes
afellows
8 - Asteroid
‎01-04-2023 03:18 AM

ex2

Final State - Exercise 2.yxdb
Reply
0 Likes
aman_goswami7
5 - Atom
‎01-04-2023 03:37 AM

Solution added

Practice Exercise 2.yxmd
Reply
0 Likes
Priyanshusoni03
6 - Meteoroid
‎01-04-2023 03:52 AM

step 1                    step 2                      step 3                 step 4                    step 5

identify data ------collect the data ------- clean data -------analyze data -------interpret data-----|

                                                                                                       |

Reply
0 Likes
Ri_ha21
5 - Atom
‎01-04-2023 05:10 AM

it was fun

Practice Exercise 2.yxmd
Reply
0 Likes