âShow Table of Contents
The Filter In-DB tool filters records with a basic filter or with a custom expression using the native language of the database, such as SQL. Use the Filter In-DB tool to query records and return records that meet the specified criteria.
In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, see In-Database Overview.
While most In-DB tools do not require SQL commands, this tool requires SQL for more advanced processing.
|!=||Does not equal|
|>||Is greater than|
|>=||Is greater than or equal to|
|<||Is less than|
|<=||Is less than or equal to|
|IS NULL||Is a missing or unknown value|
|IS NOT NULL||Is not a missing or unknown value|
|LIKE||Is similar to a specified pattern in a column|
If a query is constructed using the Basic Filter, a read-only query displays in the Custom Filter area. If the Custom Filter option is then selected, the query becomes editable.
By default, errors are reported in the results window of downstream tools.
Records that meet the specified criteria are output through the T output anchor. All other records are output through the F output anchor.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.