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
"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
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 - 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

Advanced Lookup Transform Icon

Buy Now Free Trial Download Compare Editions More Features

Task Factory Advanced Lookup Transform

Our Advanced Lookup Transform supports all the functionality of the native lookup but allows for easier use of range lookups as well as supporting non-equality lookups without writing a query. One of the biggest features of our Expression Engine is the use of Disconnected Lookups. With disconnected lookups, you can create a cache and then use that cache across multiple component instances. For instance, you can cache the product table once and then while using an Advanced Conditional Split, lookup the Product Name from the Cache without being connected to the lookup.

Feature Highlights

  • Non equality lookups like greater than and less than can be accomplished without writing a query.
  • Disconnected lookups can be used from within any task that is built on our Expression Engine (Advanced Derived Column, Advanced Conditional Split, etc).
  • Supports both in-memory and SQL CE supported cache stores for more complex and larger data lookups.
Advanced Lookup Transform

Advanced Lookup Transform - Step 1
To use the advanced lookup, the package must already contain the Advanced Cache Connection Manager. From the main editor, select the connection manager.

To use the advanced lookup, the package must already contain the Advanced Cache Connection Manager. From the main editor, select the connection manager.

Advanced Lookup Transform - Step 2
Map the column that will be used to perform the lookup. This is the column that is identified as the input parameter in the advanced cache connection manager.

Map the column that will be used to perform the lookup. This is the column that is identified as the input parameter in the advanced cache connection manager.

Advanced Lookup Transform - Step 3
To define what rows are returned, open the advanced cache connection manager and select the ‘Available Columns’ tab. Select the check box for each column that needs to be returned from the lookup.

To define what rows are returned, open the advanced cache connection manager and select the ‘Available Columns’ tab. Select the check box for each column that needs to be returned from the lookup.

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