<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.2">
<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="18">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="174" y="390" />
</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="Right_Customer_ID" selected="False" rename="Right_Customer_ID" 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="19">
<GuiSettings Plugin="AlteryxBasePluginsGui.DateTime.DateTime">
<Position x="270" y="390" />
</GuiSettings>
<Properties>
<Configuration>
<IsFrom value="False" />
<InputFieldName>Ship Date</InputFieldName>
<Format>MM/dd/yyyy</Format>
<OutputFieldName>ShipDate_Out</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.Formula.Formula">
<Position x="462" y="390" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression="DateTimeDiff([ShipDate_Out],[Order Date],"days")" field="Days to Ship" size="1073741823" type="V_WString" />
<FormulaField expression="([Unit_Price]*[Quantity_ordered_new])-[Discount]+[Shipping_Cost]" field="Subtotal of Order" size="1073741823" type="V_WString" />
<FormulaField expression="[Discount]" field="Total Saved" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Days to Ship = DateTimeDiff([ShipDate_Out],[Order Date],"days")
Subtotal of Orde...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="21">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="366" y="390" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Discount" 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="Quantity_ordered_new" selected="True" type="Double" size="8" />
<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="22">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="606" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Customer_ID" selected="False" />
<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="Product SKU" selected="False" />
<SelectField field="Discount" selected="False" />
<SelectField field="Unit_Price" selected="False" />
<SelectField field="Shipping_Cost" selected="False" />
<SelectField field="Order Date" selected="False" />
<SelectField field="Ship Date" selected="False" />
<SelectField field="Quantity_ordered_new" selected="False" />
<SelectField field="Order_ID" selected="True" />
<SelectField field="Order_Priority" selected="False" />
<SelectField field="ShipDate_Out" selected="False" />
<SelectField field="Subtotal of Order" selected="True" rename="Total" type="Double" size="8" />
<SelectField field="Total Saved" selected="True" type="Double" size="8" />
<SelectField field="Days to Ship" selected="True" type="Double" size="8" />
<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="23">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="858" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="0">
<Field field="Order_ID" order="Ascending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Order_ID - Ascending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="24">
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
<Position x="690" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<SummarizeFields>
<SummarizeField field="Order_ID" action="GroupBy" rename="Order_ID" />
<SummarizeField field="Days to Ship" action="Min" rename="Min_Days to Ship" />
<SummarizeField field="Total Saved" action="Sum" rename="Sum_Total Saved" />
<SummarizeField field="Total" action="Sum" rename="Sum_Total" />
</SummarizeFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
</Node>
<Node ToolID="25">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="786" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Order_ID" selected="True" />
<SelectField field="Sum_Total" selected="True" rename="Total" />
<SelectField field="Sum_Total Saved" selected="True" rename="Total Saved" />
<SelectField field="Min_Days to Ship" selected="True" rename="Days to Ship" />
<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="18" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="15" Connection="Output" />
<Destination ToolID="18" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="18" Connection="Join" />
<Destination ToolID="19" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="19" Connection="Output" />
<Destination ToolID="21" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="20" Connection="Output" />
<Destination ToolID="22" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="21" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Output" />
<Destination ToolID="24" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="24" Connection="Output" />
<Destination ToolID="25" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="25" Connection="Output" />
<Destination ToolID="23" 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</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>
