Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear,
From my qvd I load many customers. Some of the customers have a number, others not. I want to show in my chart if a customer has this number, with a "Yes".
Load from QVD:
Customer Number
A 9876543213
B 2135743518
C
D
E 3486135464
I want to show:
Customer Number
A Yes
B Yes
C No
D No
E Yes
I hope this is possible.
thanks a lot!
Best Regards,
Sander
Load
customer,
if(Len(NUmber)>0,'Yes','No') as Number
from
....
let me know
Load
customer,
if(Len(NUmber)>0,'Yes','No') as Number
from
....
let me know
It can also be done using
if(isnull(Number),'No','Yes') as Number
Perfect!
thanks a lot!