Congratulations on completing Exercise 2!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
.
Cheers to learning!
uploaded
Practice 2
Re: Learning Path 1: Exercise 2: General
Here are my results, I struggled to get them sorted, but eventually has the same data.
Attached the solution for practice exercise 2
Practice Ex 2 solution
solution
Solution of Practice Exercise 2
Have combined using union and then removed duplicates by using unique tool and then joined the rest using join tool on customer ID and then sorted the result by customer ID and annual transactions
Solution
Hello,
My solution
Customer_ID Store_Number Customer_Segment Region Annual Transactions Name Customer ID Address City Zip1128 108 Consumer South 150 Bob 1128 5847 Union St Arvada 800041319 108 Consumer South 150 Hudson 1319 5595 S Kenton Way Englewood 801112911 107 Home Office South 100 Lou 2911 2751 Wolff St Denver 80212466 104 Small Business South 50 Nancy 466 2721 S Truckee St Aurora 80013483 105 Corporate South 50 Drew 483 12801 E Kansas Pl Aurora 80012787 104 Home Office South 86 Jack 787 915 S Lima St Aurora 80012
Exercise 2
😀
Please find attached solution
Thank you!
My workflow
Please refer attached solved file
done
Learning Path 1: Exercise 2: General
