558 lines
20 KiB
XML
558 lines
20 KiB
XML
<?xml version="1.0"?>
|
|
<AlteryxDocument yxmdVer="2021.4">
|
|
<Nodes>
|
|
<Node ToolID="1">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
|
|
<Position x="54" y="54" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<NumRows value="3" />
|
|
<Fields>
|
|
<Field name="Column1" />
|
|
<Field name="Column 2" />
|
|
</Fields>
|
|
<Data>
|
|
<r>
|
|
<c>1</c>
|
|
<c>4</c>
|
|
</r>
|
|
<r>
|
|
<c>2</c>
|
|
<c>5</c>
|
|
</r>
|
|
<r>
|
|
<c>3</c>
|
|
<c>6</c>
|
|
</r>
|
|
</Data>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
|
|
</Node>
|
|
<Node ToolID="2">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
|
|
<Position x="186" y="54" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<OrderChanged value="False" />
|
|
<CommaDecimal value="False" />
|
|
<SelectFields>
|
|
<SelectField field="Column1" selected="True" type="Int64" size="8" />
|
|
<SelectField field="Column 2" selected="False" type="WString" size="3" />
|
|
<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="3">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
|
|
<Position x="318" y="54" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<TempFile>C:\Users\casey.morter\AppData\Local\Temp\Engine_28104_a89278053b87e446bfe970eb948f1ef4_\Engine_28104_9b8a61f4c39b2e4ea05f98886a386376~.yxdb</TempFile>
|
|
<TempFileDataProfiling />
|
|
<Layout>
|
|
<View1>
|
|
<Hints>
|
|
<Table />
|
|
</Hints>
|
|
</View1>
|
|
</Layout>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
|
|
</Node>
|
|
<Node ToolID="4">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
|
|
<Position x="54" y="246" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<NumRows value="3" />
|
|
<Fields>
|
|
<Field name="Column 3" />
|
|
<Field name="Column 4" />
|
|
<Field name="Ham" />
|
|
<Field name="Cheese" />
|
|
</Fields>
|
|
<Data>
|
|
<r>
|
|
<c>5</c>
|
|
<c>8</c>
|
|
<c>z</c>
|
|
<c>a</c>
|
|
</r>
|
|
<r>
|
|
<c>6</c>
|
|
<c>9</c>
|
|
<c>b</c>
|
|
<c>d</c>
|
|
</r>
|
|
<r>
|
|
<c>7</c>
|
|
<c>10</c>
|
|
<c>c</c>
|
|
<c>c</c>
|
|
</r>
|
|
</Data>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
|
|
</Node>
|
|
<Node ToolID="5">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
|
|
<Position x="426" y="390" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<OrderChanged value="False" />
|
|
<CommaDecimal value="False" />
|
|
<SelectFields>
|
|
<SelectField field="Column 3" selected="True" rename="Col_3_renamed" />
|
|
<SelectField field="Column 4" 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="6">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
|
|
<Position x="354" y="474" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<FormulaFields>
|
|
<FormulaField expression="[Count] + 10" field="MoreCount" size="4" type="Int32" />
|
|
</FormulaFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText><![CDATA[MoreCount = [Count] + 10
|
|
]]></DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
|
|
</Node>
|
|
<Node ToolID="7">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
|
|
<Position x="522" y="402" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration joinByRecordPos="False">
|
|
<JoinInfo connection="Left">
|
|
<Field field="Ham" />
|
|
<Field field="Cheese" />
|
|
</JoinInfo>
|
|
<JoinInfo connection="Right">
|
|
<Field field="Ham" />
|
|
<Field field="Cheese" />
|
|
</JoinInfo>
|
|
<SelectConfiguration>
|
|
<Configuration outputConnection="Join">
|
|
<OrderChanged value="False" />
|
|
<CommaDecimal value="False" />
|
|
<SelectFields>
|
|
<SelectField field="Right_Ham" selected="True" rename="Right_Ham" input="Right_" />
|
|
<SelectField field="Right_Cheese" selected="True" rename="Right_Cheese" input="Right_" />
|
|
<SelectField field="Right_Column 3" selected="True" rename="Right_Column 3" input="Right_" type="V_String" size="11" />
|
|
<SelectField field="Right_Column 4" selected="True" rename="Right_Column 4" input="Right_" type="Int64" size="8" />
|
|
<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="10">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
|
|
<Position x="618" y="486" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<TempFile>C:\Users\casey.morter\AppData\Local\Temp\Engine_28104_a89278053b87e446bfe970eb948f1ef4_\Engine_28104_c1d268f486209c40bdc02a676a529ee0~.yxdb</TempFile>
|
|
<TempFileDataProfiling />
|
|
<Layout>
|
|
<View1>
|
|
<Hints>
|
|
<Table />
|
|
</Hints>
|
|
</View1>
|
|
</Layout>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
|
|
</Node>
|
|
<Node ToolID="11">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
|
|
<Position x="450" y="618" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<FormulaFields>
|
|
<FormulaField expression="[Engine.TempFilePath]" field="Path" size="1073741823" type="V_WString" />
|
|
</FormulaFields>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText><![CDATA[Path = [Engine.TempFilePath]
|
|
]]></DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
|
|
</Node>
|
|
<Node ToolID="12">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
|
|
<Position x="330" y="618" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<Mode>First</Mode>
|
|
<N>1</N>
|
|
<GroupFields orderChanged="False" />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText>First 1</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
|
|
</Node>
|
|
<Node ToolID="13">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
|
|
<Position x="546" y="618" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<TempFile>C:\Users\casey.morter\AppData\Local\Temp\Engine_28104_a89278053b87e446bfe970eb948f1ef4_\Engine_28104_4d6ee2d9de8fac4095ab55a2bceed63e~.yxdb</TempFile>
|
|
<TempFileDataProfiling />
|
|
<Layout>
|
|
<View1>
|
|
<Hints>
|
|
<Table />
|
|
</Hints>
|
|
</View1>
|
|
</Layout>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
|
|
</Node>
|
|
<Node ToolID="14">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
|
|
<Position x="702" y="402" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<File MaxRecords="" FileFormat="0">.\SimpleWorkflowOut.csv</File>
|
|
<Passwords />
|
|
<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>SimpleWorkflowOut.csv</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
|
|
</Node>
|
|
<Node ToolID="15">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
|
|
<Position x="54" y="330" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<NumRows value="3" />
|
|
<Fields>
|
|
<Field name="Ham" />
|
|
<Field name="Cheese" />
|
|
<Field name="Count" />
|
|
</Fields>
|
|
<Data>
|
|
<r>
|
|
<c>a</c>
|
|
<c>a</c>
|
|
<c>4</c>
|
|
</r>
|
|
<r>
|
|
<c>b</c>
|
|
<c>d</c>
|
|
<c>6</c>
|
|
</r>
|
|
<r>
|
|
<c>c</c>
|
|
<c>z</c>
|
|
<c>7</c>
|
|
</r>
|
|
</Data>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
|
|
</Node>
|
|
<Node ToolID="16">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
|
|
<Position x="306" y="198" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration joinByRecordPos="False">
|
|
<JoinInfo connection="Left">
|
|
<Field field="Ham" />
|
|
<Field field="Cheese" />
|
|
</JoinInfo>
|
|
<JoinInfo connection="Right">
|
|
<Field field="Ham" />
|
|
<Field field="Cheese" />
|
|
</JoinInfo>
|
|
<SelectConfiguration>
|
|
<Configuration outputConnection="Join">
|
|
<OrderChanged value="False" />
|
|
<CommaDecimal value="False" />
|
|
<SelectFields>
|
|
<SelectField field="Right_Ham" selected="True" rename="Right_Ham" input="Right_" />
|
|
<SelectField field="Right_Cheese" selected="True" rename="Right_Cheese" input="Right_" />
|
|
<SelectField field="*Unknown" selected="True" />
|
|
</SelectFields>
|
|
</Configuration>
|
|
</SelectConfiguration>
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name>HamCheeseJoin</Name>
|
|
<DefaultAnnotationText>HamCheeseJoin</DefaultAnnotationText>
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
|
|
</Node>
|
|
<Node ToolID="17">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
|
|
<Position x="402" y="114" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<TempFile>C:\Users\casey.morter\AppData\Local\Temp\Engine_28104_a89278053b87e446bfe970eb948f1ef4_\Engine_28104_e692dab3020ec84ebe69a5de3e6990c9~.yxdb</TempFile>
|
|
<TempFileDataProfiling />
|
|
<Layout />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
|
|
</Node>
|
|
<Node ToolID="18">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
|
|
<Position x="402" y="198" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<TempFile>C:\Users\casey.morter\AppData\Local\Temp\Engine_28104_a89278053b87e446bfe970eb948f1ef4_\Engine_28104_83aac5fa43df8044b1161f8298a2a180~.yxdb</TempFile>
|
|
<TempFileDataProfiling />
|
|
<Layout />
|
|
</Configuration>
|
|
<Annotation DisplayMode="0">
|
|
<Name />
|
|
<DefaultAnnotationText />
|
|
<Left value="False" />
|
|
</Annotation>
|
|
</Properties>
|
|
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
|
|
</Node>
|
|
<Node ToolID="19">
|
|
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
|
|
<Position x="402" y="294" />
|
|
</GuiSettings>
|
|
<Properties>
|
|
<Configuration>
|
|
<TempFile>C:\Users\casey.morter\AppData\Local\Temp\Engine_28104_a89278053b87e446bfe970eb948f1ef4_\Engine_28104_c2ab20e4f5222342bc00e6424dbc38bd~.yxdb</TempFile>
|
|
<TempFileDataProfiling />
|
|
<Layout>
|
|
<View1>
|
|
<Hints>
|
|
<Table />
|
|
</Hints>
|
|
</View1>
|
|
</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="2" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="2" Connection="Output" />
|
|
<Destination ToolID="3" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="4" Connection="Output" />
|
|
<Destination ToolID="5" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="4" Connection="Output" />
|
|
<Destination ToolID="16" Connection="Left" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="15" Connection="Output" />
|
|
<Destination ToolID="16" Connection="Right" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="5" Connection="Output" />
|
|
<Destination ToolID="7" Connection="Left" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="6" Connection="Output" />
|
|
<Destination ToolID="7" Connection="Right" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="7" Connection="Right" />
|
|
<Destination ToolID="10" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="7" Connection="Join" />
|
|
<Destination ToolID="14" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="11" Connection="Output" />
|
|
<Destination ToolID="13" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="12" Connection="Output" />
|
|
<Destination ToolID="11" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="15" Connection="Output" />
|
|
<Destination ToolID="6" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="15" Connection="Output" />
|
|
<Destination ToolID="12" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="16" Connection="Left" />
|
|
<Destination ToolID="17" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="16" Connection="Join" />
|
|
<Destination ToolID="18" Connection="Input" />
|
|
</Connection>
|
|
<Connection>
|
|
<Origin ToolID="16" Connection="Right" />
|
|
<Destination ToolID="19" 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>SimpleWorkflow</Name>
|
|
<Description />
|
|
<RootToolName />
|
|
<ToolVersion />
|
|
<ToolInDb value="False" />
|
|
<CategoryName />
|
|
<SearchTags />
|
|
<Author />
|
|
<Company />
|
|
<Copyright />
|
|
<DescriptionLink actual="" displayed="" />
|
|
<Example>
|
|
<Description />
|
|
<File />
|
|
</Example>
|
|
<WorkflowId value="4b1703ae-e2d2-4561-87f2-6dbbf2f085eb" />
|
|
<Telemetry>
|
|
<PreviousWorkflowId value="ae55589b-8289-49c6-a07c-a0dc053082f8" />
|
|
<OriginWorkflowId value="ae55589b-8289-49c6-a07c-a0dc053082f8" />
|
|
</Telemetry>
|
|
</MetaInfo>
|
|
<Events>
|
|
<Enabled value="True" />
|
|
</Events>
|
|
</Properties>
|
|
</AlteryxDocument> |