I am trying to fitering the nulls records, if the input row fields has nulls or spaces , need to filter out those rows.
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?