Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
LOAD
VENDOR as "VENDOR CODE",
SUPP_PLANT,
If(len(trim(VENDOR))<=0,SUPP_PLANT,VENDOR) as VENDOR_CODE_REV,
STOR_LOC
FROM [lib://......