Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources


Buy Now Free Trial Download Compare Editions More Features

Task Factory Filter Rows Transform

Our Filter Rows Transform allows you to filter rows based on an expression. This is similar to a conditional split, but now only the rows that match the filter will be sent through to the downflow and the rows that don’t match are filtered out.

Feature Highlights

  • Extended Expression Library allows the user to create filter conditions based on expressions not available in SSIS.
  • Expression Engine supports multi-line expression which allows for more complex conditions to be created.
  • Unit Tester that comes with the expression editor allows the user to test the condition expression before running the package.
  • Expression reusability allows the user to define an expression and reuse it in other derived conditions.
  • Only rows that match the filter are sent through to the down flow.
Filter Rows Transform

Filter Rows Transform- Step 1
The configuration editor for the Filter Rows transform is an expression editor. Users have access to many more functions than they do in the native SSIS expression editor. There are a total of 187. These functions can be accessed under one folder, or grouped together under different categories.

The configuration editor for the Filter Rows transform is an expression editor. Users have access to many more functions than they do in the native SSIS expression editor. There are a total of 187. These functions can be accessed under one folder, or grouped together under different categories.

Filter Rows Transform- Step 2
To create an expression to filter rows, simply drag the column name into the expression field and build on that using any of the built in functions and operators. For example, to filter out rows based on a color column, the following expression can be used.

To create an expression to filter rows, simply drag the column name into the expression field and build on that using any of the built in functions and operators. For example, to filter out rows based on a color column, the following expression can be used.

Filter Rows Transform- Step 3
If there is more than one condition to be filtered out, then an ‘or’ statement may be used on the same line.

If there is more than one condition to be filtered out, then an ‘or’ statement may be used on the same line.

Filter Rows Transform- Step 4
In the above scenario, rows containing the values of blue and red for the color column will be passed through and rows that do not match will be dropped from the data flow. If multiple expressions are added to the transform, users can validate all expressions at once by clicking the ‘Validate All’ button.

In the above scenario, rows containing the values of blue and red for the color column will be passed through and rows that do not match will be dropped from the data flow. If multiple expressions are added to the transform, users can validate all expressions at once by clicking the ‘Validate All’ button.

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works