Some assumptions need to be made for this exercise. One, customer entries are not unique at the annual transaction level so I average the two. Also, Not all customers contain user details so i thought including all data even where user details are not available would be valuable with a additional union after the join on sale and customer join.

P.S. pipes are (Shift+\), not (ctrl+\).

JeffS

RogerL

leandrociscar

Please check

Exercise Solved...!!!

lrmsheryl

Hey there. The join tool has an embedded select, so you don't have to add in another select tool (:

Maguiness

Exercise 2 solution

arvindr

Results

abaltazarc

Practice Exercise Completed.

Here is my workflow

Practice Exercise 2

Interestng

It was Fun. 🙂

Solution Done Successfully

Ravindra_26

Please find attached solved workflow regarding exercise 2.

CherieACI

My answer

LHartsfield

practice exercise #2

rohitagarwal

Practice Exercise 2 Solutions

poushali96

The solution for exercise 2.

Srushtib

solution

sameer123

practice exercise 2 solution

gmoser63043

2 down

faishal0786

Practice Exercise 2_Faishal

Wow!

Done

Exercise 2

Practice 2 solution is attached. Thanks!

SurvaseMamta_15082004

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
<Nodes>
<Node ToolID="17">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="498" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>User Details</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="DarkBlue" /> 
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="12">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="270" width="84" height="180" />
</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.TextInput.TextInput">
<Position x="66" y="522" />
</GuiSettings>
<Properties>
<Configuration>
<NumRows value="10" />
<Fields>
<Field name="Field1" />
</Fields>
<Data>
<r>
<c>Bob|1128|5847 Union St|Arvada|80004</c>
</r>
<r>
<c>Lou|2911|2751 Wolff St|Denver|80212</c>
</r>
<r>
<c>Jack|787|915 S Lima St|Aurora|80012</c>
</r>
<r>
<c>Drew|483|12801 E Kansas Pl|Aurora|80012</c>
</r>
<r>
<c>Nancy|466|2721 S Truckee St|Aurora|80013</c>
</r>
<r>
<c>Patrice|2|376 S Jasmine St|Denver|80224</c>
</r>
<r>
<c>Zara|252|1177 Sequerra St|Broomfield|80020</c>
</r>
<r>
<c>Sherry|3310|15935 E Bethany Pl|Aurora|80013</c>
</r>
<r>
<c>Ralph|960|4851 S Genoa St|Centennial|80015</c>
</r>
<r>
<c>Hudson|1319|5595 S Kenton Way|Englewood|80111</c>
</r>
</Data>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
</Node>
<Node ToolID="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 2</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="10">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="66" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Combine both sets of Customer Transactions, then combine those entries with the User Details information.</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>

</Nodes>
<Connections>

</Connections>
<Properties>

</Properties>
</AlteryxDocument>

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335