The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.
Supported Functions
The following is a list of supported functions. See Computed Columns Functions for complete descriptions and examples of each function.
Date/Time functions
- DATE
- DATEADD
- DATEDIFF
- DATEFORMAT
- DATETRUNC
- DATEVALUE
- DAY
- DAYOFWEEK
- DAYOFYEAR
- ENDOFMONTH
- FROMUNIXTIME
- HOUR
- MAXDATE
- MIDNIGHT
- MINDATE
- MINUTE
- MONTH
- NETWORKDAYS
- NOW
- QUARTER
- SECOND
- SETTIMEZONE
- TODAY
- WEEKOFYEAR
- WORKDAY
- YEAR
Informational functions
- FIRSTNONBLANK
- ISBLANK
- ISDATE
- ISNULL
- ISNUMBER
- ISTEXT
Logical functions
- AND
- IF
- IFERROR
- NOT
- OR
Mathematical functions
- multiply, divide a column by any number
- add to, subtract from a column by any number
- ABS
- CEILING
- EXP
- FACTORIAL
- FLOOR
- INT
- LN
- LOG
- LOG10
- MOD
- POWER
- ROUND
- ROUNDDOWN
- ROUNDPERC
- ROUNDUP
- SIGN
- SQRT
- SUM
Statistical functions
- AVERAGE
- MAX
- MEDIAN
- MIN
- MODE
- STDEV
- STDEVP
- VAR
- VARP
Text functions
- CHAR
- CONCATENATE
- FIND
- HASHVALUE
- LEFT
- LEN
- LOWER
- MID
- PADLEFT
- PADRIGHT
- REGEXP
- REPEAT
- REPLACE
- REVERSE
- RIGHT
- SEARCH
- STR
- SUBSTITUTE
- TRIM
- TRIMLEFT
- TRIMRIGHT
- UPPER
- VALUE
Comparison operators
- equal to
- greater than
- greater than or equal to
- less than
- less than or equal to
- not equal to
- IF statements
#FORM FOLLOWS