Home > Transforms Nodes > Filter Columns > Expression Builder > Functions
Expression Builder includes a variety of functions that can be applied to character, numeric, and date data. There are functions that support most of the common data preprocessing required for data mining, including missing values treatment. To see a list of the available functions, expand the category of interest.
Functions are divided into the following categories
Character (including concatenate, trim, length, substring, and others)
Conversion (convert to character, date, number, and others)
Date (calculate next day, insert time stamp, truncate, round, and perform other date operations)
Numeric (includes functions such as absolute value, ceiling, floor, trigonometric functions, hyperbolic functions, logarithms, and exponentials)
Aggregate (perform aggregations)
NULL Value Substitution (for dates, characters, and numbers)
The notation for the functions is that of SQL. For more information about these functions, see the SQL Reference.