Check for multiple conditions

2 posts / 0 new
Last post
Joined: 02/12/2019 - 07:44
Check for multiple conditions

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
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.

Brian Element's picture
Brian Element
Joined: 07/11/2012 - 19:57

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.