Which tool is used to query records based on an expression and split data into different streams?

The Filter Tool is designed specifically for querying records based on a specified expression and for splitting data into different streams. When you use the Filter Tool, you define a condition or expression that evaluates each record in your dataset. Depending on whether the record meets the criteria, it will then be routed to one of two outputs: the "True" output for records that match the specified condition and the "False" output for those that do not. This capability allows users to effectively segregate data based on relevant criteria, facilitating more targeted data analysis and processing.

In contrast, the other tools mentioned serve different purposes. The Count Records Tool is primarily used to count the number of records in a dataset but does not split data. The Data Cleansing Tool focuses on cleaning and transforming data, such as removing nulls and correcting formatting issues, rather than querying and splitting. Finally, the Summarize Tool aggregates data based on specified fields or calculations, but it does not filter or create separate data streams. Therefore, the Filter Tool is the appropriate choice for querying records and directing data flows based on specific conditions.