Data Loading: create a value when one-to-many table comparison finds no match
Pardon my lack of database parlance. I think I have a pretty basic problem, but I don't know how to search for a solution.
I have two tables: patient number and diagnosis codes&sequence. Each patient could have between zero and nine diagnoses. I'm able to load and count the values just fine, but i'm having trouble identifying all the patients with zero matches on the diagnosis code&sequence table. They turn up as null in my visual, but null is not value that can be selected in QlikSense.
I don't think this situation warrants the use Applymap() because of the one-to-many relationship. Please correct me if i'm wrong.
Here's a simplified version of what I'm working with: