Script loading

[Anonymous]

Can I use the following script ?

Vente :

Load * ,

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

Resident TempVente;

drop table Vente;

[gautik92]

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

[flipside]

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]

Hi,

Try,

LOAD

*,

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

Resident TempVente;

drop table Vente;

[tamilarasu]

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]

surely you want to change your DROP statement to:

drop table TempVente;

[sunny_talwar]

I would reverse the order of true and false here

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

[tamilarasu]

My mistake