Hi guys,
how doi go about setting a field value if it is empty...
I have a field prefix... i use this field when i do a lookup to a csv file... in certain events the field prefix is empty "" and in those cases i would like to set it to 033 so it matches the lookup...
i tried using eval prefix=if(prefix="","033",prefix) but this does not work...
any ideas
Use coalesce:
| eval prefix=coalesce(prefix,"033")
or alternateively, edit your lookup table definition to to return a default value.
Use coalesce:
| eval prefix=coalesce(prefix,"033")
or alternateively, edit your lookup table definition to to return a default value.