2 Replies Latest reply: Oct 9, 2015 6:35 AM by Joanna Seldon RSS

    double null flag

    Joanna Seldon



      I wish to produce a null flag in the data load


      this works for 1 column on a record


      If(len("Depot"),0, 1) AS NullFlag,


      how do I produce a flag for each record if 2 columns in a row are null?


      e.g Depot is null and Factory is null


      Please help