I am submitting the solution to Exercise 2 with the following comments. The customer_ID 787 in the Store_Number 104 has two entries in the combined table (Start 2.1 and Start 2.2). However, Annual Transactions are different i.e. 86 and 100. If Unique Tool is used, then only one entry is left as shown in the Final State - Exercse 2 yxdb file. I think that Summarize tool should be used instead which would aggregate Annual Transactions to 186. Unless the is an error in the input data. In this case, what would be the criteria to select one of these Annual_transactions?
Could you please explain.