Element Details: Validate+Number
 Back


Available in: Logi Info Source code name: ValidateNumber

Use this element to check the characteristics of number columns. To check multiple columns using the same rules, just seperate each column name with a comma.

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

Since the concept of odd or even numbers only applies to whole numbers (integers), the system will automatically set the format to "WholeNumer" when type is odd or even.

Element Group:Validation Elements



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
AllowNulls
True
False
Determine whether null values are allowed in the column. True = (Default) Nulls are allowed. False = Nulls are not allowed.
ColumnNames
UserDefined
(Required) A list of column names, separated by commas. For example: OrderID, CustomerID, EmployeeID, OrderDate
DefaultColumnValue
UserDefined
The default value to use if the column does not contain value.
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.
MaxValue
UserDefined
The maximum value of the range.
MinValue
UserDefined
The minimum value of the range.
NumberFormat
WholeNumber
DecimalNumber
Any
Used to check for a particular number format: WholeNumber, DecimalNumber, or AnyNumber. Defaults to AnyNumber.
NumberType
PostiveNumber
OddNumber
NegativeNumber
EvenNumber
Any
Used to check for a particular number type: OddNumber, EvenNumber, PositiveNumber, NegativeNumber, AnyNumber. Since the concept of odd or even numbers only applies to whole numbers (integers), the system will automatically set the format to "WholeNumer" when type is odd or even. Defaults to AnyNumber.



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.Linked
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