This content has been marked as final.
Show 3 replies
-
Re: How do I filter for a null/empty field in an expression? IsNull doesn't behave as I'd expect.
Chanty 4u Mar 28, 2018 10:16 AM (in response to Tim Smith)try
if(isnull([Field]) OR [Field]= '','Yes','No') as field
-
Re: How do I filter for a null/empty field in an expression? IsNull doesn't behave as I'd expect.
Chanty 4u Mar 28, 2018 10:17 AM (in response to Chanty 4u)or
if(len(trim(Field))=0,0,1) as [NewField]
or
If(Len(Trim(field)) > 0, 1, 0) as [NewField]
-
-
Re: How do I filter for a null/empty field in an expression? IsNull doesn't behave as I'd expect.
Sasidhar Parupudi Mar 28, 2018 10:22 AM (in response to Tim Smith)May be try like below
Map_Product_class:
Mapping
Load
'Product Key',
'Class'
FROM qvd;
[Invoice]:
Load
'Invoice Number',
'Product Key'
Applymap('Map_Product_class', 'Product Key','Not Available in Product class') as Product_Key_Class
FROM qvd