Inner join the transaction table with the result from Move two, then you will have the entire data on the transaction desk with only each consumer's most recent history. +----+-------------+--------------------+------------+-------+-------------------------------------------------+-------------------------------------------------+---------+-------------------------------+----------+--... https://julianu320zav7.wikifrontier.com/user