Configuring the Filter and Profile activity

About this task

To configure the Filter and Profile activity complete the following steps:

Procedure

  1. In the Activities tab, open the Data Quality directory to find the Filter and  Profile activity.
  2. Add the activity to an orchestration. The Checklist and Summary for the activity are displayed beneath the orchestration.
  3. From the Checklist, select Configure and specify the following information:
    1. The variable name of the variable that contains the recurring element, which the activity loops through.
    2. The element name of the recurring element in the variable, which the activity loops through.

      Click the browse button to open the Select Recurring Element window, where you can view all the elements in the variable you selected.  

  4. From the Checklist, select Filter Expression and create an expression that the Integration Appliance uses to filter data.
    Note: The Integration Appliance can only create a profile for data that passes the filter expression. To profile all data, complete one of the following tasks:
    • Click Advanced and enter the following expression: true()

      OR

    • Enter the expression: 1 = 1
  5. From the Checklist, select Profile Summary to define parameters for the data you want to summarize.
  6. Map the output of the activity.



Feedback | Notices


Timestamp icon Last updated: Thursday, December 17, 2015


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/filter_and_profile_activity_configure.html