how to fill a blank space with a field value

[kunkumnaveen]

Hello all,

                 can any one say what is going wrong, I am trying to fill a blank value  of a field with another field value, for that what I have done is

LOAD

    VENDOR as "VENDOR CODE",

    SUPP_PLANT,

    If(VENDOR=' ',SUPP_PLANT,VENDOR) as VENDOR_CODE_REV,

    STOR_LOC

FROM [lib://......

but after doing reload I am getting

the blank space coming as blank instead of A003 value in VENDOR_CODE_REV field

[prma7799]

You can try like

If(VENDOR=Null(),SUPP_PLANT,VENDOR) as VENDOR_CODE_REV

or

If(len(VENDOR)=0,SUPP_PLANT,VENDOR) as VENDOR_CODE_REV,

[Kushal_Chawda]

LOAD

    VENDOR as "VENDOR CODE",

    SUPP_PLANT,

    If(len(trim(VENDOR))<=0,SUPP_PLANT,VENDOR) as VENDOR_CODE_REV,

    STOR_LOC

FROM [lib://......