422 lines
17 KiB
XML
422 lines
17 KiB
XML
<?xml version="1.0"?>
|
|
<AlteryxDocument yxmdVer="2022.3">
|
|
<Nodes>
|
|
<Node ToolID="2">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
|
|
<Position x="102" y="162" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<Passwords />
|
|
<File RecordLimit="" SearchSubDirs="False" FileFormat="0" OutputFileName="">..\Maven Toys Data\products.csv</File>
|
|
<FormatSpecificOptions>
|
|
<HeaderRow>True</HeaderRow>
|
|
<IgnoreErrors>False</IgnoreErrors>
|
|
<AllowShareWrite>False</AllowShareWrite>
|
|
<ImportLine>1</ImportLine>
|
|
<FieldLen>254</FieldLen>
|
|
<SingleThreadRead>False</SingleThreadRead>
|
|
<IgnoreQuotes>DoubleQuotes</IgnoreQuotes>
|
|
<Delimeter>,</Delimeter>
|
|
<QuoteRecordBreak>False</QuoteRecordBreak>
|
|
<CodePage>28591</CodePage>
|
|
</FormatSpecificOptions>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>products.csv</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
<Dependencies>
|
|
<Implicit />
|
|
</Dependencies>
|
|
<MetaInfo connection="Output">
|
|
<RecordInfo>
|
|
<Field name="Product_ID" size="254" source="File: Z:\Pyteryx\Alteryx_TestWorkflows\Maven Toys Data\products.csv" type="V_String" />
|
|
<Field name="Product_Name" size="254" source="File: Z:\Pyteryx\Alteryx_TestWorkflows\Maven Toys Data\products.csv" type="V_String" />
|
|
<Field name="Product_Category" size="254" source="File: Z:\Pyteryx\Alteryx_TestWorkflows\Maven Toys Data\products.csv" type="V_String" />
|
|
<Field name="Product_Cost" size="254" source="File: Z:\Pyteryx\Alteryx_TestWorkflows\Maven Toys Data\products.csv" type="V_String" />
|
|
<Field name="Product_Price" size="254" source="File: Z:\Pyteryx\Alteryx_TestWorkflows\Maven Toys Data\products.csv" type="V_String" />
|
|
</RecordInfo>
|
|
</MetaInfo>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
|
|
</Node>
|
|
<Node ToolID="3">
|
|
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
|
|
<Position x="570" y="162" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<SummarizeFields>
|
|
<SummarizeField field="Product_Category" action="GroupBy" rename="Product_Category" />
|
|
<SummarizeField field="Product_Category" action="Count" rename="Count" />
|
|
<SummarizeField field="Product_Cost" action="Sum" rename="Sum_Product_Cost" />
|
|
</SummarizeFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
|
|
</Node>
|
|
<Node ToolID="4">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
|
|
<Position x="342" y="162" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<OrderChanged value="False" />
|
|
<CommaDecimal value="False" />
|
|
<SelectFields>
|
|
<SelectField field="Product_Cost" selected="True" type="Float" size="4" />
|
|
<SelectField field="Product_Price" selected="True" type="Float" size="4" />
|
|
<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="5">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
|
|
<Position x="798" y="162" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<File MaxRecords="" FileFormat="0">.\Output\expected\ProductCountSumCost.csv</File>
|
|
<Passwords />
|
|
<Disable>False</Disable>
|
|
<FormatSpecificOptions>
|
|
<LineEndStyle>CRLF</LineEndStyle>
|
|
<Delimeter>,</Delimeter>
|
|
<ForceQuotes>False</ForceQuotes>
|
|
<HeaderRow>True</HeaderRow>
|
|
<CodePage>28591</CodePage>
|
|
<WriteBOM>True</WriteBOM>
|
|
</FormatSpecificOptions>
|
|
<MultiFile value="False" />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>ProductCountSumCost.csv</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
<Dependencies>
|
|
<Implicit />
|
|
</Dependencies>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
|
|
</Node>
|
|
<Node ToolID="6">
|
|
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
|
|
<Position x="570" y="306" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<SummarizeFields>
|
|
<SummarizeField field="Product_Category" action="GroupBy" rename="Product_Category" />
|
|
<SummarizeField field="Product_Cost" action="Min" rename="Min_Product_Cost" />
|
|
<SummarizeField field="Product_Cost" action="Max" rename="Max_Product_Cost" />
|
|
</SummarizeFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
|
|
</Node>
|
|
<Node ToolID="7">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
|
|
<Position x="798" y="306" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<File MaxRecords="" FileFormat="0">.\Output\expected\ProductCountMinMax.csv</File>
|
|
<Passwords />
|
|
<Disable>False</Disable>
|
|
<FormatSpecificOptions>
|
|
<LineEndStyle>CRLF</LineEndStyle>
|
|
<Delimeter>,</Delimeter>
|
|
<ForceQuotes>False</ForceQuotes>
|
|
<HeaderRow>True</HeaderRow>
|
|
<CodePage>28591</CodePage>
|
|
<WriteBOM>True</WriteBOM>
|
|
</FormatSpecificOptions>
|
|
<MultiFile value="False" />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>ProductCountMinMax.csv</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
<Dependencies>
|
|
<Implicit />
|
|
</Dependencies>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
|
|
</Node>
|
|
<Node ToolID="8">
|
|
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
|
|
<Position x="570" y="426" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<SummarizeFields>
|
|
<SummarizeField field="Product_Category" action="GroupBy" rename="Product_Category" />
|
|
<SummarizeField field="Product_Cost" action="Min" rename="Min_Product_Cost" />
|
|
<SummarizeField field="Product_Cost" action="Max" rename="Max_Product_Cost" />
|
|
</SummarizeFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
|
|
</Node>
|
|
<Node ToolID="9">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
|
|
<Position x="438" y="426" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<SortInfo locale="1033">
|
|
<Field field="Product_Category" order="Ascending" />
|
|
<Field field="Product_Cost" order="Ascending" />
|
|
</SortInfo>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>Product_Category - Ascending
|
|
Product_Cost - Ascending</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
|
|
</Node>
|
|
<Node ToolID="10">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
|
|
<Position x="234" y="162" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<FormulaFields>
|
|
<FormulaField expression="ReplaceChar([Product_Cost], "$", "")" field="Product_Cost" size="254" type="V_String" />
|
|
<FormulaField expression="ReplaceChar([Product_Price], "$", "")" field="Product_Price" size="254" type="V_String" />
|
|
</FormulaFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>Product_Cost = ReplaceChar([Product_Cost], "$", "")
|
|
Product_Price = ReplaceChar(...</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
|
|
</Node>
|
|
<Node ToolID="11">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
|
|
<Position x="678" y="162" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<FormulaFields>
|
|
<FormulaField expression="Round([Sum_Product_Cost], 0.01)" field="Sum_Product_Cost" size="8" type="Double" />
|
|
</FormulaFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText><![CDATA[Sum_Product_Cost = Round([Sum_Product_Cost], 0.01)
|
|
]]></DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
|
|
</Node>
|
|
<Node ToolID="12">
|
|
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
|
|
<Position x="570" y="534" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<SummarizeFields>
|
|
<SummarizeField field="Product_Category" action="GroupBy" rename="Product_Category" />
|
|
<SummarizeField field="Product_Cost" action="Last" rename="Last_Product_Cost" />
|
|
<SummarizeField field="Product_Name" action="Last" rename="Last_Product_Name" />
|
|
</SummarizeFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
|
|
</Node>
|
|
<Node ToolID="13">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
|
|
<Position x="798" y="426" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<File MaxRecords="" FileFormat="0">.\Output\expected\ProductCostMinMax.csv</File>
|
|
<Passwords />
|
|
<Disable>False</Disable>
|
|
<FormatSpecificOptions>
|
|
<LineEndStyle>CRLF</LineEndStyle>
|
|
<Delimeter>,</Delimeter>
|
|
<ForceQuotes>False</ForceQuotes>
|
|
<HeaderRow>True</HeaderRow>
|
|
<CodePage>28591</CodePage>
|
|
<WriteBOM>True</WriteBOM>
|
|
</FormatSpecificOptions>
|
|
<MultiFile value="False" />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>ProductCostMinMax.csv</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
<Dependencies>
|
|
<Implicit />
|
|
</Dependencies>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
|
|
</Node>
|
|
<Node ToolID="14">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
|
|
<Position x="798" y="534" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<File MaxRecords="" FileFormat="0">.\Output\expected\ProductMostExpensive.csv</File>
|
|
<Passwords />
|
|
<Disable>False</Disable>
|
|
<FormatSpecificOptions>
|
|
<LineEndStyle>CRLF</LineEndStyle>
|
|
<Delimeter>,</Delimeter>
|
|
<ForceQuotes>False</ForceQuotes>
|
|
<HeaderRow>True</HeaderRow>
|
|
<CodePage>28591</CodePage>
|
|
<WriteBOM>True</WriteBOM>
|
|
</FormatSpecificOptions>
|
|
<MultiFile value="False" />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>ProductMostExpensive.csv</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
<Dependencies>
|
|
<Implicit />
|
|
</Dependencies>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
|
|
</Node>
|
|
</Nodes>
|
|
<Connections>
|
|
<Connection>
|
|
<Origin ToolID="2" Connection="Output" />
|
|
<Destination ToolID="10" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="3" Connection="Output" />
|
|
<Destination ToolID="11" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="4" Connection="Output" />
|
|
<Destination ToolID="3" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="4" Connection="Output" />
|
|
<Destination ToolID="6" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="4" Connection="Output" />
|
|
<Destination ToolID="9" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="6" Connection="Output" />
|
|
<Destination ToolID="7" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="8" Connection="Output" />
|
|
<Destination ToolID="13" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="9" Connection="Output" />
|
|
<Destination ToolID="8" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="9" Connection="Output" />
|
|
<Destination ToolID="12" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="10" Connection="Output" />
|
|
<Destination ToolID="4" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="11" Connection="Output" />
|
|
<Destination ToolID="5" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="12" Connection="Output" />
|
|
<Destination ToolID="14" 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" />
|
|
<RunWithE2 value="True" />
|
|
<PredictiveToolsCodePage value="1252" />
|
|
<DisableAllOutput value="False" />
|
|
<ShowAllMacroMessages value="False" />
|
|
<ShowConnectionStatusIsOn value="True" />
|
|
<ShowConnectionStatusOnlyWhenRunning value="True" />
|
|
<ZoomLevel value="0" />
|
|
<LayoutType>Horizontal</LayoutType>
|
|
<MetaInfo>
|
|
<NameIsFileName value="True" />
|
|
<Name>SumToolTesting</Name>
|
|
<Description />
|
|
<RootToolName />
|
|
<ToolVersion />
|
|
<ToolInDb value="False" />
|
|
<CategoryName />
|
|
<SearchTags />
|
|
<Author />
|
|
<Company />
|
|
<Copyright />
|
|
<DescriptionLink actual="" displayed="" />
|
|
<Example>
|
|
<Description />
|
|
<File />
|
|
</Example>
|
|
<WorkflowId value="bd9c622e-55b5-45d9-b957-9f04f79ca6e4" />
|
|
<Telemetry>
|
|
<PreviousWorkflowId value="af561ec6-d0f5-46ba-a79a-ac40ca762cb9" />
|
|
<OriginWorkflowId value="af561ec6-d0f5-46ba-a79a-ac40ca762cb9" />
|
|
</Telemetry>
|
|
</MetaInfo>
|
|
<Events>
|
|
<Enabled value="True" />
|
|
</Events>
|
|
</Properties>
|
|
</AlteryxDocument> |