ageibe Member

I wish it was that simple. There should be a file associated with each encounter, but to identify which encounter is missing the file, we need to compare the file received dates with the encounter dates. The raw dataset has the files listed individually per row with a patient ID key. I combined that data with my encounters…

So unfortunately, there could be multiple encounter dates for 1 patient. So if the encounter dates were 1/1/22, 3/3/22, and 5/4/22, then I would need each of those rows (each encounter on separate row) to look at all of the file received dates in the string to make the search work. Any other thoughts?

You guys are awesome! I was doing that but apparently I was missing a step. I was able to get exactly what I needed!