How to do two conditional joins at the same time

[former_member600589]

I'm trying to understand in BO how to do two conditional joins at the same time. I'm trying to map an account number and date to another universe to get events that occurred on that date for that particular account. Doing this through SQL, Access, Tableau, etc the joins make sense but I can't figure out how to make it work in BO so that it treats the conditions simultaneously.

Example

TB1 TB2

Acct Num date Acct Num date event

000056 12/5/18 000056 5/18/18 buys shoes

000062 5/8/18 000062 6/9/18 buys pants

000062 5/8/18 buys food

So the only match I would want is 000062 on 5/8/18 to see the buys food event.

Appreciate all the help I can get.

[omacoder]

Two queries, one with account and date, and the second with the account, date and event

Within your report, merge on account and date.

[former_member600589]

I've tried that but it didn't work. I created two merged variables (acct and date) but when I try to drop the event field into my table 1 data it won't come over.