I have 2 tables. Need to Look up from Table 1 for New Cases (if same RiskIssueID is present in Table2) and Lookup from 2nd table for Closed cases if same RiskIssueID is present in Table1). How to do it. Please advice
Here if we see in both the tables, there are few common issues and some mismatch. The issues in Current month but not in previous should result as New and ones in Previous month but not in Current should come as Closed
@Kushal_Chawda Some sample data provided, apologies if the notifications are still not working in Community, if you get a chance to circle back and have a look, much appreciated.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.