new feild with null values

[Anonymous]

hi,

i build new feild in the script with an existing feild.

but in some cases the feild is null.

how i need to write it in the script ?

this is what i wrote :

if(Match([agent],500,504,509,506,505,503,502,508,null),'בנייה',
if(Match([agent],507),'תעשייה',
if(Match([agent],510),'ייצוא'))) as [תאור קוד סוכן - דוח 5]

,

thanks'

yarin.

[swuehl]

Try like this:

if(Match([agent],500,504,509,506,505,503,502,508) or len(trim([agent]))=0,'בנייה',
if(Match([agent],507),'תעשייה',
if(Match([agent],510),'ייצוא'))) as [תאור קוד סוכן - דוח 5]

[Anonymous]

hi,

it doesn't work.

now i get 2 gruops the all feild together , and the null feild alone.

i need the the nuul feild will be with the first gruop.

do you have any idea ?

[#4]

Hi,

Is 'NULL' value you have in Agent field or it like empty cell..?

If you have empty cells under Agent field insted of putting 'null' do like this ' ' else if you have value null put like this 'null'

hope it helps!!..

[Anonymous]

hi. still doesn't work.

[swuehl]

Seems to work ok for me (just using an empty agent value for demonstration instead of a NULL, but len(trim(agent)) should handle both):

LOAD *,

if(Match([agent],500,504,509,506,505,503,502,508)or len(trim(agent))=0,'בנייה',

if(Match([agent],507),'תעשייה',

if(Match([agent],510),'ייצוא'))) as [תאור קוד סוכן - דוח 5]

INLINE [

agent, field

500,1

504,2

,3

509,4

507,5

508,6

510,7

]