This message was deleted.

something in LOOKUP function such as optional 3rd argument could do it, eg

select
  LOOKUP(name, 'name_org', 'org1') as org,
  count(*)
from quoted_longs
group by LOOKUP(name, 'name_org')

or else, maybe

missingValue

or

defaultValue

attribute & value in lookup config

you can use COALESCE for this:

COALESCE(LOOKUP(name, 'name_org'), 'org1')

ah thats great - much neater, thanks!