Summary
Requirements
Open an existing Map
Edit the Driving Block to Function as a Filter
Creating an Equation for Using the Driving Block as a Filter

Summary

This article demonstrates how to use a driving block in a map as a row filter.


Requirements

1. Enterprise Enabler version 6.x
2. Map Designer

Open an existing Map

A map will require a valid source and destination template. Open Enterprise Enabler and open an existing map, go to File » Open and select Map.


Edit the Driving Block to Function as a Filter

Right click on the node under Driving Block.



This will bring up a menu, select Rule or Equation.



This will bring up the EE Equation Editor.



In the equation editor build a valid equation that returns true or false.

Equations on driving blocks expect different return values (Boolean)

then equations on regular column mappings.


Creating an Equation for Using the Driving Block as a Filter 

The key to making the driving block behave like a filter is to return true or

false as the final value. The equation will execute once for each row in the

source block that is causing the driving. For example, if source block A is a

table from a database that contains 13 rows and source block A is the

driving block, then the equation will be executed thirteen times. If only five of

those rows return true, then only 5 rows will be passed to the transformation

engine. If the equation returns true, then the row will be passed to the

transformation engine. If the equation is false, the row will be blocked from

passing to the transformation engine. The figure above shows an example of

a simple equation that can be used on a driving block, column1 is a column

from the source block that is defined as the driving block.