Filter (Superseded) - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

Outputs a filtered subset of rows from an input data set based on one or more groups of filter criteria that you define.

Note: This node has been superseded by the Filter node which provides similar functionality, but the underlying code is Python rather than Data360 Analyze Script. The Filter (Superseded) node is provided for backwards compatibility, but where possible it is recommended that you use the new Filter node.

The simplest way to filter your data is by using the Filter grid in the Filter property. Alternatively, for more advanced techniques, you can use the Advanced tab.

Note: You must choose to work in either the Filter grid or the Advanced tab, as working in one will reset the other.

Properties

Filter

Specify one or more filter criteria groups, which consist of one or more rows of filter criteria.

In the simplest case, you may wish to add just a single filter criterion to the default group provided. However, if you specify multiple criteria, you can choose to Match all (AND in Boolean logic terms), Match any (OR) or Match none (NAND) of these criteria in order to output a row of data.

By default, a single filter criteria group is created for you to populate. You can create further groups by clicking Add new criteria group. When you have multiple groups, you can then choose whether to Satisfy all groups or Satisfy any group in order to output a row from the input data set. This allows you to specify filter logic such as:

  • Match all in group 1 AND Match any in group 2
  • Match all in group 1 OR Match any in group 2 ORMatch any in group 3

The easiest way to configure the Filter (Superseded) node is to ensure that the input node has been run first. You can then simply choose a field to filter on from the drop-down list available for the Field column in the table. You can then choose an operator and specify a value.

If the input node has not been run, you can still configure your Filter (Superseded) node. In this case you must type in the name of the Field to filter on and then choose the data Type, before going on to choose an operator and specify a value. When the Filter (Superseded) node is executed, an error will be generated if this field does not exist, or exists as a different data type. Any rows in error will be highlighted in red in the filter criteria group table.

To remove a row from the criteria grid, click the menu on the far right of the row that you want to remove and select Delete. This menu will also provide any matching options available for the chosen operator, such as Match Case and Match Whole Words for String filters.

Alternatively, select the Advanced tab if you wish to create more complex filter expressions that require parentheses and specific Boolean logic, such as:

Match none in group 1 OR (Match all in group 2 ANDMatch any in group 3)

Note: Editing Script in the Advanced tab will reset the Filter grid.

If you have set your criteria using the basic filter grid, you can click the Advanced tab to view the underlying Script.

Inputs and outputs

Inputs: in1.

Outputs: out1, multiple optional.