Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

Practice Exercise

Learning Path 1: Exercise 2: General

Done

HongTran09
Átomo

Exercise 2 Solution

  

nmplache
Átomo

Exercise 2

Flow Attached 

calpav
Meteoro

Here it is

pajanno
Átomo

Practice_Exercise 2_pajanno_Solution

chinu267
Asteroide

I do not agree with the solution where you using a duplicate removal tool to remove a customer from 2.2

 

Since there is no detains of transactions for the customer how can we say that annual transaction of $100 is the duplicate? I customer could have done multiple transactions in the same store at different intervals. 

 

I used the summarize tool to roll-up all the user transactions and then used a join tool to find the desired output.

 

chinu267_0-1659508735017.png

 

 

 

MaliniB
Átomo

Completed

amy26us
Átomo

Practice Exercise 2 Solution