I have an Automatic Lookup working just fine.
Some of the values Im matching doesn't exist yet on the CSV table (they are populated once a day).
Is there any way to display UNKNOWN as a value for the field when the lookup doesnt exist on the table?
For example, if my csv lookup table looks like:
Name -- SSN
And Sometimes I dont have the Name for a SSN until the next day, so I need to mark the field as 'Unknown' when the search returns a SSN that I dont have match for the name yet.