6 Replies Latest reply: Mar 19, 2015 3:25 PM by Carolyn Lau RSS

    How to replace Null() by a string value?

    Koen Bal

      Hello,

       

      I'm trying to replace null() values of a field [Rekening tegenpartij] by the value 'geen' .

      I tried the script below. The script compiles but is not changing anything in the data.

       

      1) What is wrong in my script? Is there anything wrong with defining the Null() value?

      2) Is there another more elegant way not using the mapping function?

           Considering that I will also use the same mappingtable to replace empty values of other fields of the table Transacties.

       

      //create table to be used in mapping
      mappingtable:
      Mapping LOAD * INLINE
      [     Key, Label
            Null(), geen   ];
      
      
      //Map the empty values in Rekening tegenpartij
      LOAD
      ApplyMap( 'mappingtable' , [Rekening tegenpartij] ) as [Rekening tegenpartij]
      RESIDENT Transacties;
      
      

       

       

      Thx for your help

      _Koen