Filtering Records in Read from SAP

The filter settings in Read from SAP allow you to read a subset of records from an SAP table rather than all records in the table. To filter records, you specify the values that a record must contain in order for it to be read into the dataflow. If you do not specify any filter conditions, all records in the table are read into the dataflow. Using filter conditions is optional.

Note: If the Read from SAP stage is configured to read data from multiple SAP tables, the filter is applied after the JOIN operation is performed.
  1. In the Read from SAP stage, click the Filter tab.
  2. Click Add.
  3. In the Table name field, select the table that contains the records you want to filter.
  4. In the Filter by field, select the field that contains the data you want to use as the basis for filtering.
  5. Choose one of the following operators:
    Note: The operators available to you vary depending on the data type of the field on which you are filtering.
    Operator Description
    Contains Checks if the string contains the value specified.

    Equals

    		 Checks if the value in the field matches the value specified.
    Not Equals

    Checks if the value in the field does not match the value specified.

    Greater Than

    		 Checks if the field has a numeric value that is greater than the value specified. This operator works on numeric data types as well as string fields that contain numbers.

    Greater Than Or Equals

    		 Checks if the field has a numeric value that is greater than or equal to the value specified. This operator works on numeric data types as well as string fields that contain numbers.

    Less Than

    		 Checks if the field has a numeric value that is less than the value specified. This operator works on numeric data types as well as string fields that contain numbers.
    Less Than Or Equals

    Checks if the field has a numeric value that is less than or equal to the value specified. This operator works on numeric data types as well as string fields that contain numbers.
    Is Null Checks if the field is a null value.

    Is Not Null

    		 Checks if the field is not a null value.
    Starts With Checks if the field starts with the value specified.
    Ends With Checks if the field ends with the value specified.
  6. Enter the value to which you want to compare the selected field's value.
  7. Click OK.
  8. Add additional filter conditions if needed.
    Note: If you specify multiple filter conditions, all the filter conditions must be true in order for the record to be read into the dataflow. If any one of the conditions is not true, the record is not read into the dataflow.