Failure filter

This filter allows to filter records based on the output of cleansing services. Output is divided into valid and invalid.

Filter Query optimizer Concurrent Distributed execution possible
  • VALID

  • INVALID

  • Email traffic light column

    Email traffic light

    InputColumn<TrafficLight> Optional
  • Email traffic light level

    Email traffic light level (first invalid value)

    Choice: Green Grey Orange Red Failure Optional
  • Fail on empty email

    Consider empty value as invalid.

    boolean Optional
  • Person traffic light column

    Person traffic light

    InputColumn<TrafficLight> Optional
  • Person traffic light level

    Person traffic light level (first invalid value)

    Choice: Green Grey Orange Red Failure Optional
  • Fail on empty person

    Consider empty person name as invalid.

    boolean Optional
  • Company traffic light column

    Company traffic light

    InputColumn<TrafficLight> Optional
  • Company traffic light level

    Company traffic light level (first invalid value)

    Choice: Green Grey Orange Red Failure Optional
  • Fail on empty company

    Consider empty company name as invalid.

    boolean Optional
  • Phone traffic light column

    Phone traffic light column

    InputColumn<TrafficLight> Optional
  • Phone traffic light level

    Phone traffic light level (first invalid value)

    Choice: Green Grey Orange Red Failure Optional
  • Fail on empty phone

    Consider empty phone as invalid.

    boolean Optional
  • Address error column

    Address error column

    InputColumn<String> Optional
  • Address error level

    Address error level (first invalid value)

    Choice: Valid Corrected to valid Invalid Optional
  • Address deceased column

    Address 'is deceased' column

    InputColumn<String> Optional
  • Address deceased level

    Address 'is deceased' invalid value

    boolean Optional
  • Address change of address flagged column

    Address 'change of address (flagged)' column

    InputColumn<String> Optional
  • Address change of address flagged level

    Address 'change of address (flagged)' invalid value

    boolean Optional
  • Address do not mail column

    Address 'do not mail' column

    InputColumn<String> Optional
  • Address do not mail level

    Address 'do not mail' invalid value

    boolean Optional