When searching a lookup and the user is not found then I need the result to be NULL.
Any ideas?
You can specify a default value in case there's no match in your lookup definition.
The lookup
command will use your settings from the lookup defintion:
... | lookup your_lookup_definition your_input_field OUTPUT your_output_fields
or whateverHow do I with the command?