use "others" for lookup results

[aquinojason]

Hi,

Currently I am using a lookup table to match an account code to an application. How can I make it in such a way that if the account code does match anything to my lookup table it uses "others" instead.

Thanks and Regards,

[ITWhisperer · Accepted solution]

After the lookup, use fillnull value="others" application

[aquinojason]

Thanks! Although I used eval and isnull funtion since there are other fields in the table that might contain null values as well.

[ITWhisperer]

fillnull can be applied to specific fields e.g. application but eval and isnull works too