Intersection of 2 datasets

[quilldew]

Hi,

I've asked this question in one manner, and not found a solution yet, so lets try a different tack 😂

I have a table that appears similar to below:

And i'd like to be able to create a table that only shows the referrals to a non-Urgent Service, where the UserID has also had contact with an Urgent Service, and where the Contact_Date for that Urgent Service is after the RefDate of the referral of the non-Urgent Service.

So based on the above table it would show:

This is a simple version of my actual tables, what i'm essentially trying to do is using p() create a couple of datasets, then intersect them, and then perform =if()'s on the resulting table.

Where I'm running into issues is the limitation on one expression within the p(), adding any other set analysis treats the additions as an 'OR'.

[siddheshmane]

Could you share a sample data.