Hey there,
What effect does the parameter 'Ignore Nulls' in SQLExecutor have?
Or in other words: What happens when the SQL statement doesn't give a result? In my workspace these features are not going through the Result-output. In fact, they get lost :-(.
I know I can do several workarounds, e.g. merge the output with the initiator via an unique attribute or modify my SQL statement (which will be something like 'select nvl(min(ATTR),'doe') from ...'), but I expected the parameter 'Ignore Nulls' might give me the non-resulting features with a NULL-value in the result.
-Maria (using FME 2021.0)
