This guide will help you get an idea how filtering can be done. For instance, we want to filter out any record where the first column is not equal to A and the second column is not equal to B.

STEP #1. Configure data source connectors

1) To start with, drag-and-drop data source connectors to Apatar's work panel.

2) Configure the connectors, providing the necessary authentication details and the paths to the servers.

3) Drag-and-drop the Filter operation icon, as well.

4) Map the nodes together as it is shown in the picture below.

     

Please note that the source and output tables should have the identical data structures! (The same rows, columns, and data types.) Otherwise, you need to use the Transform operation between the Filter node and output connector.

     

STEP #2. Configure Filter operation node

1) Double-click on the Filter node to configure it.

2) Drag-and-drop the fields that define the filtration criteria. In this example, the first column is "c11", and the second one is "field3".

3) Set the filtration criteria. For instance, we want to filter out all the entries with the values which are not equal to a certain number or string. In this case, we need to use the Equal logic function, mapped with the Not logic function. Please, see the picture.

     

3) Now we need to set the values for both Equal nodes. To do so, double-click on each Equal node and enter the value you want to use as a filtration criteria.

     

According to this picture, we compare the values of the entries from the "c11" column with the nubmer 2.

Since we also have the Not node mapped with the Equal function, all of the entries which are not equal to 2, will be filtered out.

The similar configuration should be provided for another Equal function node.

STEP #3. Run the filtration

Start the filtration process. Either choose Run from Apatar's File menu, or select "Preview Results" right-clicking on the output connector.

All filtered data will be saved to the output data source. In our example, the "table1_true" table was used for this purpose.