Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , how can i get only empty value for a filed thanks gidon
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
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
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
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
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
Hi Miguel
thanks for your promt answer
it helps
gidon