Practice Exercise

Learning Path 1: Exercise 2: General

CindyZilavy
5 - Atom

Completed.

omercado05
7 - Meteor

Here is my solution.

IzaG
5 - Atom

Done! 

jgalbert
6 - Meteoroid

Hello, 

I have completed the exercise 2 but I have a question, I grouped the customer ID and the store number so that the transactions would sum and have a total of 186 so that there were no duplicates but in the final solution I see that that they did not do that and only picked up the first 787 customer ID record and only the 86 transactions.  I don't feel that would be correct for the requirement as it would miss the 100 transactions.  Can you explain why the final solution did not take the total sum of the transactions into account for the duplicate records?  Thanks so much.  

I have attached my workflow.. 

 

Janice 

sangeethadetne
7 - Meteor

Please find the solution of Practice_2

msuatgunerli
5 - Atom

PE 2 - msuatgunerli solution

msuatgunerli
5 - Atom

I envisioned it differently and assumed that the greater of the two input values would be the correct one and went on to sort both the Customer_ID and Annual Transactions columns before using the Unique tool keep the 100 and discard the 86, was quite surprised to see that the result they wanted was the opposite. 

pmarrone
6 - Meteoroid

That was fun.

erickcp15
6 - Meteoroid

Here is the next submission

SamuelOtisi
7 - Meteor

My solution is here