Filter Node
The Filter node isolates specific data based on a number or string condition. Use one or add multiple conditional statements to drill down data. You can also change ‘And’ to ‘Or’ to include or exclude data according to conditional statements.
Let’s dig a little deeper. The conditional statements available for string inputs are:
- Equal: Select all data that Equals a specific text value. Note here that the entire value must match the data; if I’m looking for all the “draft” values, then it is necessary to enter the exact value while respecting upper and lower case letters.
- Not Equal: This is the opposite of Equal; select all data that does not equal a specified text value.
- Begins With: Select all data that starts with a specified text value. The difference here is that the data does not have to match the entire value. For example, show only data that starts with the letter “d.” Case sensitivity is still important here so it makes a difference using “D” vs. “d.”
- Ends With: ‘Ends With’ is the opposite of ‘Begins With’; select all data that ends with a specified text value.
- Contains: Select all data that has a specified text value anywhere within the data. If this time I use “d,” then the Select node will output all values that have “d” anywhere in the data (i.e. draft, closed, Closed, etc...)
Here’s a look at conditional statements available for number inputs:
- Equal: Select all data that Equals the exact numerical value.
- Not Equal: ‘Not Equal’ is the opposite of Equal; select all data that does not equal a specified numerical value.
- Bigger Than: Select all data that has a higher value than a specified number input.
- Bigger Than or Equal: Select all data that is at least and higher value than a specified number input.
- Less Than Select all data that has a lower value than a specified numerical input.
- Less Than or Equal: Select all data that is at least and smaller value than a specified number input.
Comments
0 comments