5 Replies Latest reply: Oct 27, 2014 11:59 AM by Mark O'Donovan RSS

    "null" value to "1"

    Aurimas Driskius

      Hi all,

       

      I have SQL table, how to set up , if the value is " null " written 1. Using my script i'm i get value "-"

       

       

      /Sample/

       

      [products]:

      LOAD ID as [item.ID],

          Name as [pr.name],

          Code as [pr.code],

          TareWeight as [pr.twt],

          if ((TareWeight='Null') or (TareWeight=0),1,TareWeight) as [Weight]

          ;

      SQL SELECT *

      FROM postgres."public".erpoitm