6 Replies Latest reply: Aug 18, 2016 10:04 AM by John Cavoulas RSS

    Update value for Blank cells

    Ramu Subramaniyan

      Hi

       

      I have table as below and would like update blank cells in B to 0 (zero) for row 2,5,6.

       

      TabA: 

      AB
      1100
      2
      3300
      4400
      5
      6
      7700

       

      But i know the below script to replace value.  is there any other ways to replace value for table without full resident load again especially with joins or something in script

      TabB:

      A,

      If(len(B)=0,0,B) as B

      resident TabA;

       

      regards

      Ramu