Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

Empty cell

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

5 Replies
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
Champion
Champion

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

Sunil Chauhan
gidon500
Creator II
Creator II
Author

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

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
Creator II
Creator II
Author

Hi Miguel

thanks for your promt answer

it helps

gidon