<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
<Nodes>
<Node ToolID="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="318" width="84" height="96" />
</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.DbFileInput.DbFileInput">
<Position x="66" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Start 1.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 1.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="255" source="File: " type="V_String" />
<Field name="Store_Number" size="255" source="File: " type="V_String" />
<Field name="Customer_Segment" size="255" source="File: " type="V_String" />
<Field name="Region" size="255" source="File: " type="V_String" />
<Field name="TransInYear" source="Formula: Round(([TransactionsPerYear]*50), 1)" type="Int16" />
<Field name="Weekly Sales" source="Formula: round(([FinUniversity]*[Income]),.01)" type="Double" />
<Field name="Store Volume" source="File: " type="Double" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="7">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 1</Text>
<Font name="Arial" size="22" style="1" /> <!-- Updated font style -->
<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="6">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.</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="8">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="186" width="492" height="108" />
</GuiSettings>
<Properties>
<Configuration>
<Text>An Input Data tool contains 100 records, each representing a unique customer's transaction information...</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="10">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="606" y="318" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Final State Updated</Text> <!-- Changed annotation 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="13">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="174" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Weekly Sales" selected="False" />
<SelectField field="Store Volume" selected="False" />
<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="14">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="270" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="0">
<Field field="TransInYear" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>TransInYear - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="15">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="366" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>5</N>
<GroupFields orderChanged="False">
<Field name="Region" />
</GroupFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 5</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="16">
<GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
<Position x="474" y="330" />
</GuiSettings>
<Properties>
<Configuration>
<Expression>[Region] = "East"</Expression> <!-- Changed filter condition to "East" -->
<Mode>Simple</Mode>
<Simple>
<Operator>=</Operator>
<Field>Region</Field>
<Operands>
<IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
<DateType>fixed</DateType>
<PeriodDate>2019-10-10 17:41:12</PeriodDate>
<PeriodCount>0</PeriodCount>
<Operand>East</Operand>
</Operands>
</Simple>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>[Region] = "East"</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="18">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="618" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\Users\DE-76951\AppData\Local\Temp\Engine_10752_8d3f868a7e7a45d9be6f2b27d7521989_\Engine_18160_dbdb509f03a240fa9cb278aa5a345726_.yxdb</TempFile>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="13" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="13" Connection="Output" />
<Destination ToolID="14" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="14" Connection="Output" />
<Destination ToolID="15" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="15" Connection="Output" />
<Destination ToolID="16" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="16" Connection="True" />
<Destination ToolID="18" 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 1_Thomas</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>
