(warning) 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