How to create a join with a condition- first key standard join & 2nd key is a negative join

JonDix

Hello Fellow Monarch End-Users, 

I was wondering if there is a way to do a join where there are two keys and the first key has to match but the second key can't match? For this example, I want to show the rows where the member number matches but the FSR doesn't. So half negative join and half standard join.  Has anyone created such a join combination and if so how would you recommend to accomplish this.  Thank you.

------------------------------
Jon Dix
Research Analyst
Founders Federal Credit Union
Lancaster SC
(803) 289-5277
------------------------------

CPorthouse

I would try doing a join on the member number and with the resulting table create a new formula field that compares if the the two FSR columns match or not.  You can then filter on that column.

------------------------------
Chris Porthouse
Senior Implementation & Integration Engineer
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 09-26-2019 04:34 PM
From: Jon Dix
Subject: How to create a join with a condition- first key standard join & 2nd key is a negative join

Hello Fellow Monarch End-Users,

I was wondering if there is a way to do a join where there are two keys and the first key has to match but the second key can't match? For this example, I want to show the rows where the member number matches but the FSR doesn't. So half negative join and half standard join.  Has anyone created such a join combination and if so how would you recommend to accomplish this.  Thank you.

------------------------------
Jon Dix
Research Analyst
Founders Federal Credit Union
Lancaster SC
(803) 289-5277
------------------------------
"