This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.