verifying null in two caolumns

[#1]

Hi All,

I have two columns customer,Currency

customer,currency

-,-

-,-

If customer is null and Currency is null.I want to replace null in customer with some text ex;'Speciality'

How can I achieve this?

Thanks,

Mahendra.

[Agis-Kalogiannis]

Hi Mahendra

You can do something like

load

  if(customer=null() and Currency=null(), 'Speciality', customer) AS customer,

  Currency

FROM ...

Agis

[maxgro]

if(IsNull(customer) and IsNull(currrency), 'Speciality', customer) as customer

or

if(len(trim(customer))=0 and len(trim(currrency))=0, 'Speciality', customer) as customer