7 Filter

This section provides information about the Filter component.
  1. Drag and drop the Filter component onto the canvas to define a filter for an entity such as EDD (Insert Connector) or ADI (Extract Connector).
  2. To position the component on the canvas, either drag and move it, or click the component and use the arrow keys on the keyboard to adjust its position.
  3. If filter component accepts input only from an entity and can have only one output.
  4. To apply filters to multiple entities, drag and drop the corresponding number of filters. Connect each filter to its respective entity and define their expressions. For example, to add a filter to three entities, place three filters on to the canvas and connect them accordingly.
  5. At any time, right-click the filter 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, showing selected entities and parameters. Specify the required filter expression using columns and parameters.
  7. Click Validate to verify the correctness of the SQL Expression.
  8. Click OK to confirm and apply the filter expression.

    Note:

    • You do not need to add a WHERE clause for the filter.
    • For file data loading, use the filter expression of the type Number with single quotes. For example: N_DRAWN_AMOUNT = '40000'.
    • For the Date field, see To_CHAR function for comparison.
    • 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’)