Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Mahendra
You can do something like
load
if(customer=null() and Currency=null(), 'Speciality', customer) AS customer,
Currency
FROM ...
Agis
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