Compare+Columns Details

Element Details: Compare+Columns

Available in: Logi Info

Source code name: CompareColumns

Use this element to compare the value of two columns on the same record. For example, this element could be used to check that a start date is before a finish date.

Any records of data that contain invalid data are removed. In order to access the removed data, add a value to the ExceptionDataID attribute.

Element Group:Validation Elements

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

CompareType

NotEqual

LessThanOrEqual

LessThan

GreaterThanOrEqual

GreaterThan

Equal

(Required) Defines the type of comparison to perform.

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.

LeftCompareColumn

UserDefined

(Required) The name of a column used for the "left" side of the comparison.

RightCompareColumn

UserDefined

(Required) The name of a column used for the "right" side of the comparison.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.