I'm stumped by a workflow I'm trying to build that needs to join data from a leave payment report and another report that captures elections for using PTO to top up leave pay. I can't seem to find a combination of join fields and/or uniques that gets me to my desired output. I'd hoped to avoid wrestling with joining on dates, but that may be what I need to do. Other unique fields that I've tried are Case Number, EIN, Payment ID, etc but I can't quite get it right. I'm attaching a chunk of my workflow, the dummy data, and my desired output. Halp, please!
