topic Re: Changing NULL Value to a specific value in load statement in QlikView

Changing NULL Value to a specific value in load statement

Fri, 21 Sep 2012 13:38:36 GMT

Hi,

In one the tables in the DB I have a field name Subscriber.

Here are the following valus for that.

1. Print

2. Digital

3. Null

I am using QV 10 and want to change Null with 'Non Subscriber'

Is it possible to specify it in the load statement? If yes can someone write the statement?

Thanks,

PS: Is it also possible to change Digital with something else...."Digital+Print" for example?

Re: Changing NULL Value to a specific value in load statement

MayilVahanan — Fri, 21 Sep 2012 13:43:53 GMT

Try like this,

Load *, if(Subscriber='Null','Non Subscriber',Subscriber) as Subscriber from tablename;

Edit:

For Ps:

Load *, if(fieldName = 'Digital', 'DigitalPrint',FieldName) as FieldName from table;

Hope it helps

Re: Changing NULL Value to a specific value in load statement

swuehl — Fri, 21 Sep 2012 13:44:25 GMT

Maybe like this?

LOAD

pick(

match(Subscriber,'Print','Digital')+1,

'Non Subscriber',

'Print',

'Digital+Print'

) as Subscriber

FROM Table;

Re: Changing NULL Value to a specific value in load statement

alexpanjhc — Fri, 21 Sep 2012 13:46:51 GMT

use the following statement in your load:

if( isnull(Subscriber), 'Non Subscriber', if(Subscriber='Digital', 'Digital+Print' ,Subscriber)) as Subscriber

Re: Changing NULL Value to a specific value in load statement

Fri, 21 Sep 2012 14:13:15 GMT

Ramasamy,

Thanks a lot. I found what I was looking for with your idea. Didn't try the others.

Thanks all.

Re: Changing NULL Value to a specific value in load statement

alexpanjhc — Fri, 21 Sep 2012 14:18:57 GMT

I do not think that was a correct answer.

You can not determine a null value by using if Subscriber='Null', you need to use isnull() function.

Hope that helps.

Re: Changing NULL Value to a specific value in load statement

Fri, 21 Sep 2012 14:20:39 GMT

Alexpanjhc,

Well, you might be right. Infact for now I just tried his "PS" part and it worked. 🙂