How can I create a lookup where if the user is not found, the result should be NULL?

[dlcrooks]

When searching a lookup and the user is not found then I need the result to be NULL.

Any ideas?

[martin_mueller]

You can specify a default value in case there's no match in your lookup definition.

[martin_mueller]

The lookup command will use your settings from the lookup defintion:

• in the lookup definition, set minimum matches to 1 or greater
• in the lookup definition, set the default matches to whatever string you like
• use ... | lookup your_lookup_definition your_input_field OUTPUT your_output_fields or whatever

[dlcrooks]

How do I with the command?