filter Transformation Parameters

When you define a filter transformation, you set the action attribute to filter Transformation and specify the parameters.

This table describes the settings for the filter node in the dataflow editor.

Setting	Required?	Value
Source	Yes	Node in the dataflow definition file that contains the dataset that you want to filter.
Use SAQL	No	Select whether to use a SAQL expression in the filter.
Filter	No	Standard filter expression that specifies which records to include in the new dataset. See filter Expression Syntax. This field is visible when the Use SAQL option isn't selected.
SAQL Filter	No	SAQL filter expression that specifies which records to include in the new dataset. See filter Expression Syntax. This field is visible when the Use SAQL option is selected.

This table describes the input parameters for the filter transformation in the dataflow JSON.

Parameter	Required?	Value
filter	No	Filter expression that specifies which records to include in the new dataset. See filter Expression Syntax.
saqlFilter	No	SAQL filter expression that specifies which records to include in the new dataset. See filter Expression Syntax.
source	Yes	Node in the dataflow definition file that contains the dataset that you want to filter.

Note You can include either the filter parameter or the saqlFilter parameter in a filter node in the dataflow JSON, but not both.

Product Area