This guide will help you learn how to filter out the records that contain a certain text.

Configuration

To start filtering records with the Does Not Contain function,

1. Configure data sources and provide the mapping
   
   
   
   In this example, we will use the following custom table:
   
   
   
   
2. Open the Filter (or Validate) node
3. Click on the String section to find the Does Not Contain icon
4. Drag-and-drop it to the Filtration's work panel
   
   
   
   
5. As well, drag-and-drop the field that may contain the unwanted string
6. Map the nodes according to the picture below
   
   
   
   
7. Double-click on the Does Not Contain node to configure the function
8. Enter the text that should not be contained in the records
   
   
   
   
9. Press Ok
10. Close the Filtration window

Now the output table will contain only those records where the Column2 field does not contain the specified text.

Preview

To preview the results, right-click on the output node and select "Preview Results". The following window will pop up.

     

Now you can close the window and continue data integration.

See also

     Contain Function