<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
<Nodes>
<Node ToolID="12">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="450" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Order 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="11">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="594" y="306" 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="7">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="306" 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 3.1.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 3.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 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="8">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 3</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="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Combine the customer information from the last exercise with "Order Details" to find the Total and Total Saved for each order.</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="10">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="186" width="420" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Combine the customer information in "Start 3.1" with the "Order Details". Ensure both the "Order Date" and "Ship Date" columns are formatted as "date" datatype.
Find the number of days to ship after the order was placed for each line item. Also calculate the subtotal for each line item (discount and shipping are flat costs, not per quantity). Finally, find the Total cost for each order, the "Total Saved" for each order, and the minimum days to ship any line item within each order.</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="15">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="66" y="474" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Order Details.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Order Details.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="255" source="(Multiple Sources)" type="V_String" />
<Field name="Product SKU" size="255" source="File: " type="V_String" />
<Field name="Discount" size="255" source="(Multiple Sources)" type="V_String" />
<Field name="Unit_Price" size="255" source="File: " type="V_String" />
<Field name="Shipping_Cost" size="255" source="File: " type="V_String" />
<Field name="Order Date" source="DateTime: To MM/dd/yyyy" type="Date" />
<Field name="Ship Date" size="22" source="DateTime: (Multiple Sources)" type="String" />
<Field name="Quantity_ordered_new" size="255" source="File: " type="V_String" />
<Field name="Order_ID" size="255" source="File: " type="V_String" />
<Field name="Order_Priority" size="255" source="File: " type="V_String" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="17">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="606" y="330" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Final State - Exercise 3.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Final State - Exercise 3.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Order_ID" size="255" source="Summarize: GroupBy - Order_ID" type="V_String" />
<Field name="Total" source="Summarize: Sum - SubTotal" type="Double" />
<Field name="Total Saved" source="Summarize: Sum - Discount" type="Double" />
<Field name="Days to Ship" source="Formula: DateTimeDiff([Ship_Date],[Order Date],"days")" type="Byte" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="19">
<GuiSettings Plugin="AlteryxBasePluginsGui.DateTime.DateTime">
<Position x="150" y="474" />
</GuiSettings>
<Properties>
<Configuration>
<IsFrom value="False" />
<InputFieldName>Ship Date</InputFieldName>
<Format>MM-dd-yyyy</Format>
<OutputFieldName>Shipping Date</OutputFieldName>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Convert Ship Date From:
MM-dd-yyyy</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDateTime" />
</Node>
<Node ToolID="20">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="234" y="462" />
</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="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Left_Store_Number" selected="True" input="Left_" />
<SelectField field="Left_Customer_Segment" selected="True" input="Left_" />
<SelectField field="Left_Name" selected="True" input="Left_" />
<SelectField field="Left_Address" selected="True" input="Left_" />
<SelectField field="Left_City" selected="True" input="Left_" />
<SelectField field="Left_Zip" selected="True" input="Left_" />
<SelectField field="Right_Customer_ID" selected="True" rename="Right_Customer_ID" input="Right_" />
<SelectField field="Right_Product SKU" selected="True" input="Right_" />
<SelectField field="Right_Discount" selected="True" input="Right_" />
<SelectField field="Right_Unit_Price" selected="True" input="Right_" />
<SelectField field="Right_Shipping_Cost" selected="True" input="Right_" />
<SelectField field="Right_Order Date" selected="True" input="Right_" />
<SelectField field="Right_Ship Date" selected="True" input="Right_" />
<SelectField field="Right_Quantity_ordered_new" selected="True" input="Right_" />
<SelectField field="Right_Order_ID" selected="True" input="Right_" />
<SelectField field="Right_Order_Priority" selected="True" input="Right_" />
<SelectField field="Right_Shipping Date" selected="True" 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>
<Node ToolID="21">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="390" y="462" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression="([Unit_Price]*[Quantity_ordered_new])+[Shipping_Cost]" field="Subtotal" size="8" type="Double" />
<FormulaField expression="([Unit_Price]*[Quantity_ordered_new])+[Shipping_Cost]-[Discount]" field="Total" size="8" type="Double" />
<FormulaField expression="DateTimeDiff([Ship Date],[Order Date],"days")" field="Days to Ship" size="8" type="Double" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Subtotal = ([Unit_Price]*[Quantity_ordered_new])+[Shipping_Cost]
Total = ([Unit_...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="22">
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
<Position x="474" y="462" />
</GuiSettings>
<Properties>
<Configuration>
<SummarizeFields>
<SummarizeField field="Order_ID" action="GroupBy" rename="Order_ID" />
<SummarizeField field="Total" action="Sum" rename="Total" />
<SummarizeField field="Discount" action="Sum" rename="Total Saved" />
<SummarizeField field="Days to Ship" action="Min" rename="Days to Ship" />
</SummarizeFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
</Node>
<Node ToolID="23">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="306" y="462" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Store_Number" selected="False" />
<SelectField field="Customer_Segment" selected="False" />
<SelectField field="Name" selected="False" />
<SelectField field="Address" selected="False" />
<SelectField field="City" selected="False" />
<SelectField field="Zip" selected="False" />
<SelectField field="Right_Customer_ID" selected="False" rename="Customer_ID" />
<SelectField field="Order_ID" selected="True" />
<SelectField field="Quantity_ordered_new" selected="True" type="Double" size="8" />
<SelectField field="Unit_Price" selected="True" type="Double" size="8" />
<SelectField field="Shipping_Cost" selected="True" type="Double" size="8" />
<SelectField field="Discount" selected="True" type="Double" size="8" />
<SelectField field="Order Date" selected="True" />
<SelectField field="Shipping Date" selected="True" rename="Ship Date" />
<SelectField field="Ship Date" selected="False" type="V_String" size="22" />
<SelectField field="Product SKU" selected="False" />
<SelectField field="Order_Priority" selected="False" />
<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="24">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="558" y="462" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\Users\E867948\AppData\Local\Temp\Engine_17520_cb2a86953fc74b8dbabdbbcfe8566978_\Engine_16844_26ce3082b931448b8cc9d43d0a174b4c_.yxdb</TempFile>
<TempFileDataProfiling />
<Layout>
<ViewMode>Single</ViewMode>
<ViewSize value="100" />
<View1>
<DefaultTab>Profile</DefaultTab>
<Hints>
<Table />
</Hints>
</View1>
<View2 />
</Layout>
</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="20" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="19" Connection="Output" />
<Destination ToolID="20" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="15" Connection="Output" />
<Destination ToolID="19" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="20" Connection="Join" />
<Destination ToolID="23" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="21" Connection="Output" />
<Destination ToolID="22" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Output" />
<Destination ToolID="24" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="23" Connection="Output" />
<Destination ToolID="21" 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 3_Snare</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>
