Hi there,
I have the following two tables that i'm trying make a test as below:
Table 1
User | transaction
User1 | transaction1
User1 | transaction2
User1 | transaction3
User1 | transaction 4
and
Table 2
Case ID | 1st transaction | 2nd transaction | 3rd transaction
Case 1 | transaction1 | transaction 2 | transaction 4
My test involves checking if transaction 1,2 and 4 from table 2 are found in table 1 for the same user, and output the case id. It can happen that a user has multiple cases as well.
Appreciate any recommendations on how to best approach this.
rosiminoal
Offline
Last seen: 4 years 6 months ago
Joined: 02/12/2019 - 07:44
Just a thought and I haven't tested it. But for table 1 could you now do a summary by user and transaction with a criteria that you are only interested in transaction 1, 2 and 4. You then do a second summary on your first summary but only by user, if the user has 3 records then that would mean they have transactions 1, 2 and 4.