âShow Table of Contents
The Filter tool queries records by using an expression and splits data into two outputs: True, where the data meets the specified criteria, and False, where the data does not meet the specified criteria.
Use this tool to identify records in your data that meet a specified criteria. You may choose to handle records that come from the True output differently than the False output by connecting additional tools to the workflow on either side.
Select the type of filter to use.
Basic Filter: Use the basic filter to quickly build a simple query on a single field in the incoming data steam.
- Click Pick Field and select existing data to apply an expression.
- Click the drop-down in the next field and select the operator to use. Depending on the data type of the selected field, choose from the following basic operators:
= Equals != 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 Is Empty Value is Null or "" Is Not Empty Value is Not Null or "" Contains Value includes any part of the string (case sensitive)
- Type a value in the next field to complete the expression.
If you are filtering on dates, the default value will be today's date. Use the calendar drop down to pick from the calendar to properly format the date value.
Custom Filter: Use the custom filter to build a more complex expression or to query from multiple fields in the data stream.
Use any of these methods to build an expression:
Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.