ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Practice Exercise

Learning Path 1: Capstone: General

subh61
6 - Meteoroid
‎03-16-2025 10:19 PM

Hi

Capstone.yxmd
Reply
0 Likes
heshwanthnaagv
6 - Meteoroid
‎03-17-2025 05:08 AM

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.2">
<Nodes>
<Node ToolID="31">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="402" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Supplied Benchmark Data</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="30">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="234" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Supplied Survey Data</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="270" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">Engagment Data.xlsx|||`Sheet1$`</File>
<FormatSpecificOptions>
<FirstRowData>False</FirstRowData>
<ImportLine>1</ImportLine>
</FormatSpecificOptions>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Engagment Data.xlsx
Table=`Sheet1$`</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Field 1" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 2" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 3" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 4" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 5" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 6" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 7" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 8" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 9" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 10" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
<Field name="Field 11" size="255" source="File: C:\Users\blundebjerg\AppData\Local\Packages\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\TempState\Downloads\Capstone (1)\Engagment Data.xlsx|||`Sheet1$`" type="V_String" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="17">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
<Position x="66" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<NumRows value="6" />
<Fields>
<Field name="Name" />
<Field name="1" />
<Field name="2" />
<Field name="3" />
<Field name="4" />
</Fields>
<Data>
<r>
<c>Department</c>
<c>Customer Operations</c>
<c>Customer Support</c>
<c>HR</c>
<c>Training</c>
</r>
<r>
<c>Q1:I understand how my role contributes to the company's mission.</c>
<c>4.1</c>
<c>5.8</c>
<c>5.3</c>
<c>5.1</c>
</r>
<r>
<c>Q2:My work is recognized by leadership.</c>
<c>4.8</c>
<c>4.6</c>
<c>5.4</c>
<c>4.4</c>
</r>
<r>
<c>Q3:I have access to the resources I need to achieve success.</c>
<c>6.1</c>
<c>5.7</c>
<c>5.2</c>
<c>4</c>
</r>
<r>
<c>Q4:I would recommend this workplace.</c>
<c>5.8</c>
<c>4.2</c>
<c>6.2</c>
<c>4.5</c>
</r>
<r>
<c>Q5:I feel informed of Senior Leadership's strategies and vision.</c>
<c>5.2</c>
<c>4.6</c>
<c>4.1</c>
<c>3.9</c>
</r>
</Data>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
</Node>
<Node ToolID="40">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="210" y="54" width="528" height="48" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Capstone Exercise</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="36">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="102" width="792" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text><![CDATA[Use what you've learned to make the engagement survey results more end-user oriented. Start by calculating the Departmental averages for each question.

Then add in the Industry Benchmark data and compare the results. Scores averaging 1 point below benchmark should be flagged for REVIEW. ]]></Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="1" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="41">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="810" y="222" 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="43">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="822" y="246" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Final State - Capstone.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Final State - Capstone.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Department" size="2048" source="Summarize: GroupBy - Department" type="V_String" />
<Field name="#" size="2" source="Transpose:" type="String" />
<Field description="TextToColumns: Parsed from Name" name="Question" size="65" source="TextToColumns: Parsed from Name" type="V_String" />
<Field name="Score" source="Summarize: (Multiple Sources)" type="Double" />
<Field name="Benchmark" source="TextInput:" type="Double" />
<Field name="Delta" source="Formula: [Score]-[Benchmark]" type="Double" />
<Field name="Review" size="1073741823" source="Formula: if [Delta]&lt;-1 then &quot;REVIEW&quot; else &quot;&quot; endif" type="V_WString" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="59">
<GuiSettings Plugin="AlteryxBasePluginsGui.RecordID.RecordID">
<Position x="174" y="270" />
</GuiSettings>
<Properties>
<Configuration>
<FieldName>RecordID</FieldName>
<StartValue>1</StartValue>
<FieldType>Int32</FieldType>
<FieldSize>6</FieldSize>
<Position>0</Position>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxRecordID" />
</Node>
<Node ToolID="60">
<GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
<Position x="270" y="270" />
</GuiSettings>
<Properties>
<Configuration>
<Expression>[RecordID] = 2 OR [RecordID] = 4 OR [RecordID] = 6 OR [RecordID] = 8 OR [RecordID] = 10 OR [RecordID] = 12 OR [RecordID] = 14</Expression>
<Mode>Custom</Mode>
<Simple>
<Operator>=</Operator>
<Field>
</Field>
<Operands>
<IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
<DateType>fixed</DateType>
<PeriodDate>2019-10-11 09:55:27</PeriodDate>
<PeriodType>
</PeriodType>
<PeriodCount>0</PeriodCount>
<Operand>
</Operand>
<StartDate>2019-10-11 09:55:27</StartDate>
<EndDate>2019-10-11 09:55:27</EndDate>
</Operands>
</Simple>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>[RecordID] = 2 OR [RecordID] = 4 OR [RecordID] = 6 OR [RecordID] = 8 OR [RecordI...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="61">
<GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
<Position x="390" y="258" />
</GuiSettings>
<Properties>
<Configuration>
<ErrorWarn>Warn</ErrorWarn>
<KeyFields>
<Field field="RecordID" />
</KeyFields>
<DataFields>
<Field field="RecordID" selected="False" />
<Field field="Field 1" selected="True" />
<Field field="Field 2" selected="True" />
<Field field="Field 3" selected="True" />
<Field field="Field 4" selected="True" />
<Field field="Field 5" selected="True" />
<Field field="Field 6" selected="True" />
<Field field="Field 7" selected="True" />
<Field field="Field 8" selected="True" />
<Field field="Field 9" selected="True" />
<Field field="Field 10" selected="True" />
<Field field="Field 11" selected="True" />
<Field field="*Unknown" selected="True" />
</DataFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
</Node>
<Node ToolID="62">
<GuiSettings Plugin="AlteryxBasePluginsGui.CrossTab.CrossTab">
<Position x="510" y="258" />
</GuiSettings>
<Properties>
<Configuration>
<GroupFields>
<Field field="Name" />
</GroupFields>
<HeaderField field="RecordID" />
<DataField field="Value" />
<Methods>
<Method method="Concat" />
<Separator>,</Separator>
<FieldSize value="2048" />
</Methods>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Name" size="8" source="CrossTab:Group:Concat:" type="String" />
<Field name="2" size="2048" source="CrossTab:Header:RecordID:2:Concat:" type="V_String" />
<Field name="4" size="2048" source="CrossTab:Header:RecordID:4:Concat:" type="V_String" />
<Field name="6" size="2048" source="CrossTab:Header:RecordID:6:Concat:" type="V_String" />
<Field name="8" size="2048" source="CrossTab:Header:RecordID:8:Concat:" type="V_String" />
<Field name="10" size="2048" source="CrossTab:Header:RecordID:10:Concat:" type="V_String" />
<Field name="12" size="2048" source="CrossTab:Header:RecordID:12:Concat:" type="V_String" />
<Field name="14" size="2048" source="CrossTab:Header:RecordID:14:Concat:" type="V_String" />
</RecordInfo>
<SortInfo>
<Field field="Name" order="Asc" />
</SortInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxCrossTab" />
</Node>
<Node ToolID="63">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="594" y="258" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Name" selected="False" />
<SelectField field="2" selected="False" />
<SelectField field="4" selected="True" rename="Department" />
<SelectField field="6" selected="True" rename="Q1" type="Double" size="8" />
<SelectField field="8" selected="True" rename="Q2" type="Double" size="8" />
<SelectField field="10" selected="True" rename="Q3" type="Double" size="8" />
<SelectField field="12" selected="True" rename="Q4" type="Double" size="8" />
<SelectField field="14" selected="True" rename="Q5" 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="64">
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
<Position x="702" y="258" />
</GuiSettings>
<Properties>
<Configuration>
<SummarizeFields>
<SummarizeField field="Department" action="GroupBy" rename="Department" />
<SummarizeField field="Q1" action="Avg" rename="Q1" />
<SummarizeField field="Q2" action="Avg" rename="Q2" />
<SummarizeField field="Q3" action="Avg" rename="Q3" />
<SummarizeField field="Q4" action="Avg" rename="Q4" />
<SummarizeField field="Q5" action="Avg" rename="Q5" />
</SummarizeFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
</Node>
<Node ToolID="65">
<GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
<Position x="174" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<ErrorWarn>Warn</ErrorWarn>
<KeyFields>
<Field field="Name" />
</KeyFields>
<DataFields>
<Field field="Name" selected="False" />
<Field field="1" selected="True" />
<Field field="2" selected="True" />
<Field field="3" selected="True" />
<Field field="4" selected="True" />
<Field field="*Unknown" selected="True" />
</DataFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
</Node>
<Node ToolID="66">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="270" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression="If [Name2] = &quot;1&quot; Then &quot;Customer Operations&quot; elseif [Name2] = &quot;2&quot; then &quot;Customer Support&quot; elseif [Name2] = &quot;3&quot; then &quot;HR&quot; Else &quot;Training&quot; Endif" field="Department" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Department = If [Name2] = "1" Then "Customer Operations" elseif [Name2] = "2" th...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="67">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="366" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>Skip</Mode>
<N>4</N>
<GroupFields orderChanged="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Skip 1st 4</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="68">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextToColumns.TextToColumns">
<Position x="462" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<Field>Name</Field>
<ErrorHandling>Last</ErrorHandling>
<RootName>
</RootName>
<Delimeters value=":" />
<NumFields value="2" />
<Flags value="0" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextToColumns" />
</Node>
<Node ToolID="69">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="570" y="438" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Name" selected="False" />
<SelectField field="Name2" selected="False" />
<SelectField field="Department" selected="True" />
<SelectField field="1" selected="True" rename="#" />
<SelectField field="2" selected="True" rename="Question" />
<SelectField field="Value" selected="True" rename="Benchmark" />
<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="70">
<GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
<Position x="726" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<ErrorWarn>Warn</ErrorWarn>
<KeyFields>
<Field field="Department" />
</KeyFields>
<DataFields>
<Field field="Department" selected="False" />
<Field field="Q1" selected="True" />
<Field field="Q2" selected="True" />
<Field field="Q3" selected="True" />
<Field field="Q4" selected="True" />
<Field field="Q5" selected="True" />
<Field field="*Unknown" selected="True" />
</DataFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
</Node>
<Node ToolID="71">
<GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
<Position x="822" y="426" />
</GuiSettings>
<Properties>
<Configuration joinByRecordPos="False">
<JoinInfo connection="Left">
<Field field="Department" />
<Field field="Name" />
</JoinInfo>
<JoinInfo connection="Right">
<Field field="Department" />
<Field field="#" />
</JoinInfo>
<SelectConfiguration>
<Configuration outputConnection="Join">
<OrderChanged value="True" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Left_Department" selected="True" input="Left_" />
<SelectField field="Left_Name" selected="False" input="Left_" />
<SelectField field="Right_Department" selected="False" rename="Right_Department" input="Right_" />
<SelectField field="Right_#" selected="True" input="Right_" />
<SelectField field="Right_Question" selected="True" input="Right_" />
<SelectField field="Left_Value" selected="True" rename="Score" input="Left_" />
<SelectField field="Right_Benchmark" selected="True" input="Right_" type="Double" 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="72">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="906" y="426" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression="[Score] - [Benchmark]" field="Delta" size="8" type="Double" />
<FormulaField expression="IF [Delta]&lt;=-1 THEN &quot;REVIEW&quot; ELSE &quot;&quot; ENDIF" field="Review" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Delta = [Score] - [Benchmark]
Review = IF [Delta]&lt;=-1 THEN "REVIEW" ELSE "" ENDI...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="73">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="978" y="426" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="0">
<Field field="Delta" order="Ascending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Delta - Ascending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="59" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="17" Connection="Output" />
<Destination ToolID="65" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="59" Connection="Output" />
<Destination ToolID="60" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="60" Connection="True" />
<Destination ToolID="61" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="61" Connection="Output" />
<Destination ToolID="62" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="62" Connection="Output" />
<Destination ToolID="63" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="63" Connection="Output" />
<Destination ToolID="64" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="64" Connection="Output" />
<Destination ToolID="70" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="65" Connection="Output" />
<Destination ToolID="66" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="66" Connection="Output" />
<Destination ToolID="67" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="67" Connection="Output" />
<Destination ToolID="68" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="68" Connection="Output" />
<Destination ToolID="69" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="69" Connection="Output" />
<Destination ToolID="71" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="70" Connection="Output" />
<Destination ToolID="71" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="71" Connection="Join" />
<Destination ToolID="72" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="72" Connection="Output" />
<Destination ToolID="73" 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>Capstone</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>

Reply
0 Likes
RebekaMazuchova
8 - Asteroid
‎03-17-2025 06:03 AM

yay

Capstone.yxmd
Reply
0 Likes
Jonathon-Sheppard
8 - Asteroid
‎03-17-2025 10:58 AM

Bit of a different way to go about it, but here you go.

I struggled to begin with to provide a solution that used ONLY the tools we've learned so far on the 'Getting Started' learning path.

I had read solutions from others who ended up using tools we HAVEN'T used on the pathway, but I was determined to find some way of doing it 'by the book' so to speak!

It is laborious and I'm sure there's a quicker way of doing this (which I hope I'll learn later on), and my solution does differ from the format of the 'Final State' in the exercise.

 

However, from the simple brief of averaging dept scores for each question, comparing them against the provided benchmark scores and flagging certain answers for review - my workflow does provide the answer, just in a different way / in a different format.

 

I also didn't want to 'cheat' and download the solution as a guide. I wanted to test the skills I've learned so far and push the many ways one might achieve the same results.

Capstone.yxmd
Reply
0 Likes
owenpifer
6 - Meteoroid
‎03-18-2025 09:59 AM

Capstone Project

Capstone.yxmd
Reply
0 Likes
ahastings
6 - Meteoroid
‎03-18-2025 12:22 PM

Capstone

 

Capstone_AJH.yxmd
Reply
0 Likes
Zach_Thomason
7 - Meteor
‎03-19-2025 02:41 PM

This was a tough one at first but I enjoyed it. 

Capstone_Zthomason_Refined.yxwz
Reply
0 Likes
samruddhibhujbal28
6 - Meteoroid
‎03-20-2025 02:20 AM

Here is the Solution.

Capstone_solution.yxmd
Reply
0 Likes
kelseysbooth
7 - Meteor
‎03-20-2025 07:46 AM

Capstone submission

Capstone.yxmd
Reply
0 Likes
Felipeboni
7 - Meteor
‎03-21-2025 06:44 AM

Spolier.png

Capstone.yxmd
Reply
0 Likes