To configure the Filter and Profile activity complete the
following steps:
Procedure
- In the Activities tab, open the Data
Quality directory to find the Filter and Profile activity.
- Add the activity to an orchestration. The Checklist and Summary for
the activity are displayed below the orchestration.
- From the Checklist, select Configure and
specify the following information:
- The variable name of the variable
that contains the recurring element, which the activity loops through.
- 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 above.
- 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
- From the Checklist, select Profile
Summary to define parameters
for the data you want to summarize.
- Map the output of
the activity.