community Alteryx IO Alteryx.com
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
Free Trial

Practice Exercise

Learning Path 1: Exercise 1: General

lkirschner
5 - Atom
a month ago

See attached.

Practice Exercise 1.yxmd
Reply
0 Likes
Thejaswi2024
5 - Atom
a month ago

      <FormatSpecificOptions />

        </Configuration>

        <Annotation DisplayMode="0">

          <Name />

          <DefaultAnnotationText>Final State - Exercise 1.yxdb</DefaultAnnotationText>

          <Left value="False" />

        </Annotation>

        <Dependencies>

          <Implicit />

        </Dependencies>

        <MetaInfo connection="Output">

          <RecordInfo>

            <Field name="Customer_ID" size="255" source="File: " type="V_String" />

            <Field name="Store_Number" size="255" source="File: " type="V_String" />

            <Field name="Customer_Segment" size="255" source="File: " type="V_String" />

            <Field name="Region" size="255" source="File: " type="V_String" />

            <Field name="Annual Transactions" source="Formula: Round(([TransactionsPerYear]*50),

Reply
0 Likes
Thejaswi2024
5 - Atom
a month ago

?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
<Nodes>
<Node ToolID="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="318" 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 1.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 1.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="255" source="File: " type="V_String" />
<Field name="Store_Number" size="255" source="File: " type="V_String" />
<Field name="Customer_Segment" size="255" source="File: " type="V_String" />
<Field name="Region" size="255" source="File: " type="V_String" />
<Field name="TransInYear" source="Formula: Round(([TransactionsPerYear]*50), 1)" type="Int16" />
<Field name="Weekly Sales" source="Formula: round(([FinUniversity]*[Income]),.01)" type="Double" />
<Field name="Store Volume" source="File: " type="Double" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="7">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 1</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="6">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.</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="8">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="186" width="492" height="108" />
</GuiSettings>
<Properties>
<Configuration>
<Text>An Input Data tool contains 100 records, each representing a unique customer's transaction information. The Customer ID (a unique identifier for each customer) and Customer Segment provide basic information about the customer. The transactions column represents the average number of transactions that customer has made over the past year.

In this exercise, drop the columns "Weekly Sales" and "Store Volume". Then find the 5 customers with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.</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="10">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="606" y="318" 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="13">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="174" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Weekly Sales" selected="False" />
<SelectField field="Store Volume" 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="14">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="270" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="0">
<Field field="TransInYear" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>TransInYear - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="15">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="366" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>5</N>
<GroupFields orderChanged="False">
<Field name="Region" />
</GroupFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 5</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="16">
<GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
<Position x="474" y="330" />
</GuiSettings>
<Properties>
<Configuration>
<Expression>[Region] = "South"</Expression>
<Mode>Simple</Mode>
<Simple>
<Operator>=</Operator>
<Field>Region</Field>
<Operands>
<IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
<DateType>fixed</DateType>
<PeriodDate>2019-10-10 17:41:12</PeriodDate>
<PeriodType>
</PeriodType>
<PeriodCount>0</PeriodCount>
<Operand>South</Operand>
<StartDate>2019-10-10 17:41:12</StartDate>
<EndDate>2019-10-10 17:41:12</EndDate>
</Operands>
</Simple>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>[Region] = "South"</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="18">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="618" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\Users\DE-76951\AppData\Local\Temp\Engine_10752_8d3f868a7e7a45d9be6f2b27d7521989_\Engine_18160_dbdb509f03a240fa9cb278aa5a345726_.yxdb</TempFile>
</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="13" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="13" Connection="Output" />
<Destination ToolID="14" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="14" Connection="Output" />
<Destination ToolID="15" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="15" Connection="Output" />
<Destination ToolID="16" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="16" Connection="True" />
<Destination ToolID="18" 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 1_Thomas</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>

?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
<Nodes>
<Node ToolID="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="318" 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 1.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 1.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="255" source="File: " type="V_String" />
<Field name="Store_Number" size="255" source="File: " type="V_String" />
<Field name="Customer_Segment" size="255" source="File: " type="V_String" />
<Field name="Region" size="255" source="File: " type="V_String" />
<Field name="TransInYear" source="Formula: Round(([TransactionsPerYear]*50), 1)" type="Int16" />
<Field name="Weekly Sales" source="Formula: round(([FinUniversity]*[Income]),.01)" type="Double" />
<Field name="Store Volume" source="File: " type="Double" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="7">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 1</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="6">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.</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="8">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="186" width="492" height="108" />
</GuiSettings>
<Properties>
<Configuration>
<Text>An Input Data tool contains 100 records, each representing a unique customer's transaction information. The Customer ID (a unique identifier for each customer) and Customer Segment provide basic information about the customer. The transactions column represents the average number of transactions that customer has made over the past year.

In this exercise, drop the columns "Weekly Sales" and "Store Volume". Then find the 5 customers with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.</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="10">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="606" y="318" 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="13">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="174" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Weekly Sales" selected="False" />
<SelectField field="Store Volume" 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="14">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="270" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="0">
<Field field="TransInYear" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>TransInYear - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="15">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="366" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>5</N>
<GroupFields orderChanged="False">
<Field name="Region" />
</GroupFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 5</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="16">
<GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
<Position x="474" y="330" />
</GuiSettings>
<Properties>
<Configuration>
<Expression>[Region] = "South"</Expression>
<Mode>Simple</Mode>
<Simple>
<Operator>=</Operator>
<Field>Region</Field>
<Operands>
<IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
<DateType>fixed</DateType>
<PeriodDate>2019-10-10 17:41:12</PeriodDate>
<PeriodType>
</PeriodType>
<PeriodCount>0</PeriodCount>
<Operand>South</Operand>
<StartDate>2019-10-10 17:41:12</StartDate>
<EndDate>2019-10-10 17:41:12</EndDate>
</Operands>
</Simple>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>[Region] = "South"</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="18">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="618" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\Users\DE-76951\AppData\Local\Temp\Engine_10752_8d3f868a7e7a45d9be6f2b27d7521989_\Engine_18160_dbdb509f03a240fa9cb278aa5a345726_.yxdb</TempFile>
</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="13" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="13" Connection="Output" />
<Destination ToolID="14" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="14" Connection="Output" />
<Destination ToolID="15" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="15" Connection="Output" />
<Destination ToolID="16" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="16" Connection="True" />
<Destination ToolID="18" 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 1_Thomas</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>

Practice Exercise 1_Thomas.yxmd
Reply
0 Likes
howei0316
5 - Atom
a month ago

Answer

Practice Exercise 1.yxmd
Reply
0 Likes
RonitGupta
7 - Meteor
4 weeks ago

Solution

Reply
0 Likes
jarrydoosthuyse
5 - Atom
4 weeks ago

Good day,

Find attached my solution to practice exercise 1.

 

Kind regards,

Jarryd

Practice Exercise 1 (correct).yxzp
Reply
0 Likes
jarrydoosthuyse
5 - Atom
4 weeks ago

Find attached.

Practice Exercise 1 (correct).yxzp
Reply
0 Likes
dawaldmann
5 - Atom
4 weeks ago

-

Practice Exercise 1.yxmd
Reply
0 Likes
Tgcmp
6 - Meteoroid
4 weeks ago

Here follows!

Practice Exercise 1 - Solution made by me.yxmd
Reply
0 Likes
Sreenivas_dasappagari
5 - Atom
4 weeks ago

hi 

Practice Exercise 1.yxmd
Reply
0 Likes