2 Replies Latest reply: Dec 9, 2015 4:33 PM by Hemantha Kumar Gandrothu RSS

    Excluding "empty" rows

    Derek O'Brian

      I have a table which has 7 fields and it is getting additional rows where the first field is filled but the fields 2-6 are blank.

      I need to load (resident) ONLY the rows where any one of fields 2-6 are are complete.

      I have tried (and had no success) with "LOAD * Resident CSRelated ...

           where not isnull(Field1) and

      (not isnull(Field3) or
      not isnull(Field4) or
      not isnull(Field5) or
      not isnull(Field6) or
      not isnull(Field7))

           ;

      or

             where len(Field2&Field3&Field4&Field5&Field6&Field7)>0;

       

      or any number of other permutations.

       

      Suggestions please. Thanks

       

      @excluderow