Empty cell

[gidon500]

Hi , how can i  get  only  empty value for a filed   thanks gidon

[Miguel_Angel_Baeyens]

Hi,

If you mean you want to add an empty value to a field, do as follows in the script:

Table:
LOAD Field1,
     Field2
     Null() AS EmptyField,
     '' AS EmptyField_2
FROM ...

Hope that helps.

Miguel

[SunilChauhan]

if(isnull(fieldName),fieldName)  as fieldName

or

if(fieldName=' ',fieldName)  as fieldName

or

if(len(fieldName)=0' ',fieldName)  as fieldName

use above inside scripe

hope this helps

[gidon500]

Hi Miguel

thanks for your prompt answer  ,

i have a field name CREDIT  , only in some of the recoder this field get a value

i want to define as a new filed  AA  in the same record if the value of the filed is null

thanks

gidon

[Miguel_Angel_Baeyens · Accepted solution]

Hi Gidon,

Then something like this code should work:

Table:
LOAD CREDIT,
     If(Len(Trim(CREDIT)) = 0, 1) AS AA // when CREDIT is null, AA = 1
FROM ...

Hope that helps.

Miguel

[gidon500]

Hi Miguel

thanks for your promt answer

it helps

gidon