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

    double null flag

    Joanna Seldon

      Hiya

       

      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