Joining rules using ANY on one type, but ALL on another
Hi,
I’m doing a join of two sets of data, and struggling for the following reason:
There are three points of contact which can be connected in data set, so data set 1 ‘email’ is set to match ‘any’ of data set 2s ‘email 1’, ‘email 2’, or ‘email 3’.
However, in that same join I need to connect DS 1 ‘Enquiry Date’ to DS 2 ‘date_enquired’, but as I have selected ‘Any of the following’ to cater for the emails, this means it’s not working with the enquiry date. Is there a way to have the joiner’s matching criteria set to have ‘any’ with the emails, but ‘all’ with the dates?