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.
It was easy even for me! 😉
Solution for Practice Exercise 2
Here's my workflow.
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+\).
Please check
Exercise Solved...!!!
Hey there. The join tool has an embedded select, so you don't have to add in another select tool (:
Exercise 2 solution
Results
Practice Exercise Completed.
Here is my workflow
Practice Exercise 2
..
Interestng
It was Fun. 🙂
.
Solution Done Successfully
Please find attached solved workflow regarding exercise 2.
My answer
practice exercise #2
Practice Exercise 2 Solutions
The solution for exercise 2.
solution
practice exercise 2 solution
2 down
Practice Exercise 2_Faishal
Wow!
Done
Exercise 2
Practice 2 solution is attached. Thanks!