1 Reply Latest reply on Oct 8, 2017 9:01 AM by Nico Heinze

    Filter --> space and nulls

    Kareem M Seasoned Veteran

      Hi Everyone,

       

      I am trying to fitering the nulls records, if the input row fields has nulls or spaces , need to filter out those rows.

       

      IIF(

      ISNULL(INPUT_FIELD1) OR IS_SPACES(INPUT_FIELD1) AND

      ISNULL(INPUT_FIELD2) OR IS_SPACES(INPUT_FIELD2) AND

      ISNULL(INPUT_FIELD3) OR IS_SPACES(INPUT_FIELD3)

      , FALSE, TRUE)

       

       

      I used the above condition in expression t/s and calling this as flag in filter t/s.

       

      Rows which has nulls are filtering and rows whcih space as value is not filtering and these row is populating into target tables.

       

      Can any one suggest to filter nulls and spaces please?

       

      Thanks,