The only thing missing at the moment is to check for duplicates within the customer transactions once you have combined them both together.
The only difference in the fields for some of them is the annual transactions, so if you use a Unique Tool and select the Customer ID, Store Number, Customer Segment and Region then it should provide you with the correct final output
