Element Details: Compare+Columns
 Back


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.

NamePossible ValuesDescription
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.
ID
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.

DataLayer.Cached
DataLayer.CSV
DataLayer.Directory
DataLayer.ETL
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.JSON
DataLayer.LDAP
DataLayer.Plugin
DataLayer.REST
DataLayer.SimpleDB
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug