12.3.4 Filter

This section provides information about the Filter component.

1. Drag and drop the Filter component on the canvas to define a filter on an entity such as EDD (Insert Connector)/ADI (Extract Connector).
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. It accepts input only from an entity and can have only one output.
4. To have filters for multiple entities, drag and drop as many filters as the number of entities you want to filter, connect each filter to its respective entity, and then define their expressions. Example: To add a filter to three entities, add three filters on to the canvas.
5. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
6. To define the filter expression, double-click filter component. The Filter Expression Window is displayed. The selected entities and parameters are displayed. Specify the required filter expression using columns and parameters. Click Validate to verify the correctness of the SQL Expression. Click OK.
7. You need not add the ‘WHERE’ clause for the filter.

   Note:

   1. For file data loading, use the filter expression of the type Number along with single quotes. For example: N_DRAWN_AMOUNT ='40000'.
   2. For the Date field, see To_CHAR function for comparison.
   3. Parameters can also be used in the filter expression. The date format must be a valid SQL Date Format.
   For Example:
   [EDD_GL_DATA].[EXTRACTION_DATE] = TO_DATE(#DIHDEV.MIS_DATE,’dd-MM-yyyy’)