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