Internal join the transaction table with the end result from Action two, then you should have the complete documents with the transaction table with only Each individual shopper's most current record. With out that join, the one information you would've from the acquisition desk would be the date as well https://bobbyp627lcr2.wikievia.com/user