Field with value NULL

[#1]

Hi all,

Somebody can help me?

Like the sample attached, how can I create a column ( name K) with value 5 if value k1 is Null and value Altro is not NULL, otherwise K set up with value of field K1?

Thank All

[#2]

Hi,

Attach your data sources.

i could see only application.

- Sridhar

[#3]

Hi,

Try droping your 1st table using below code.

drop table Sez1;

Note:

The above drop statement should be the last line of your script.

- Sridhar

[sathishkumar_go]

HI try this expression

if

(IsNull(K1) =-1 and IsNull(Altro)=0, 5) as K

its not working then attach ur excel file here

-Sathish

[#5]

Sorry,

Now I attach the file QLV and the file Excel.

Thank All

[#6]

Hi,

Check the attahed application now.

I would suggest you to go for len() function instead of isnull()

- Sridhar