Hello @Anonymous and welcome to Microsoft Q&A.
If a property is missing, its value may be considered null. With that in mind,
One options could be using a Lookup transformation to find any row whose keyfield value is null.
The isNull(thing)
function will be useful for that. It returns true when the thing is null, and false when not null. On the other side we fill in true()
.