topic Re: Script loading in QlikView

Script loading

Anonymous — Wed, 21 Oct 2015 09:40:37 GMT

Can I use the following script ?

Vente :

Load * ,

IF(comp is null , 'O',comp) as Comp

Resident TempVente;

drop table Vente;

gautik92 — Wed, 21 Oct 2015 09:49:00 GMT

IF(Isnull(comp), 'O',comp) as Comp

flipside — Wed, 21 Oct 2015 09:51:51 GMT

If comp contains only numeric values, use the Alt function ...

Alt(comp,0) as Comp

.. otherwise use IsNull ...

If(IsNull(comp),'0',comp) as Comp

flipside

Gabriel — Wed, 21 Oct 2015 09:56:57 GMT

Hi,

Try,

LOAD

IF(ISNULL(Comp) OR LEN(Comp) = 0, 0, Comp) AS FieldName

Resident TempVente;

drop table Vente;

tamilarasu — Wed, 21 Oct 2015 10:11:56 GMT

Hi,

Another solution

Vente :
Load * ,
IF(Len(Trim(comp))>0, 0,comp) as Comp


Resident TempVente;


drop table TempVente;

Above script will work, even for blank cells.

marcus_malinow — Wed, 21 Oct 2015 10:20:38 GMT

surely you want to change your DROP statement to:

drop table TempVente;

sunny_talwar — Wed, 21 Oct 2015 10:24:09 GMT

I would reverse the order of true and false here

If(Len(Trim(comp)) > 0, comp, 0) as Comp

tamilarasu — Wed, 21 Oct 2015 10:32:41 GMT

My mistake