2 Replies Latest reply: Jul 6, 2017 6:16 AM by kushal chawda RSS

    how to fill a blank space with a field value

    naveen kumar

      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

       

      blank.PNG

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