2 Replies Latest reply: May 29, 2018 1:50 PM by Satish Kurra RSS

    Replacing Blank values with Null()

    Rahul Patel

      Hi All,

       

      I have a requirement where I have to replace blanks in the existing field values which has blanks with Null
      (). For this requirement I'm using  if( len(trim(CORP))=0, null(), CORP).

       

      The above requirement works with single field, but I have to do the same thing for all the fields available in the data set. Can anyone help me how to replace blanks for the entire dataset's available across all fields with Null().

       

      Thanks

      Rahul