Contains+Filter Details

Element Details: Contains+Filter

Available in: Logi Info

Source code name: ContainsFilter

Checks the values of each record in a data layer and filters out any records that do not contain the target string.

If the ExceptionDataID attribute has a value, the removed records can be used in additional processing. If the ExceptionDataID does not have a value, then the records are simply deleted from the returned datalayer.

Element Group:Filter Rows

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

ColumnNames

UserDefined

(Required) A list of column names, separated by commas. For example: OrderID, CustomerID, EmployeeID, OrderDate

ExceptionDataID

UserDefined

Defines an ETL ID value that can be used to address the exception data that was removed by the filter. The value of this attribute may be referenced by a DataLayer.ETL, LoadDbTable, SaveData, or any other element that supports the EtlElementID attribute.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

IgnoreCase

True

False

Defaults to False for comparisons.

TargetString

UserDefined

(Required) The string value to seach for.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.