Date: Thu, 29 Jul 2021 13:21:02 +0000 (GMT) Message-ID: <840875353.27189.1627564862149@6a789edf488b> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_27188_6555984.1627564862149" ------=_Part_27188_6555984.1627564862149 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Language Index

# Language Index

This section contains an index to all of the objects available in  = Wrangle .

## Aggregate Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
ANY Function Extracts a non-null and non-missing value from = a specified column. If all values are missing or null, the function returns= a null value. See ANY Function.=
ANYIF Function Selects a single non-null value from rows in ea= ch group that meet a specific condition. See ANYIF Function.
AVERAGE Function Computes the average (mean) from all row values= in a column. Input column can be of Integer or Decimal. See AVERAGE Function.
AVERAGEIF Function Generates the average value of rows in each gro= up that meet a specific condition. Generated value is of Decimal type. = ; See AVERAGEIF Function. =
COUNTA Function Generates the count of non-null rows in a speci= fied column, optionally counted by group. Generated value is of Integer typ= e.  See COUNTA Function.=
COUNTAIF Function Generates the count of non-null values for rows= in each group that meet a specific condition. See COUNTAIF Function.
COUNTDISTINCT Function Generates the count of distinct values in a spe= cified column, optionally counted by group. Generated value is of Integer t= ype.  See COUNTDISTIN= CT Function.
COUNTDISTINCTIF Function Generates the count of distinct non-null values= for rows in each group that meet a specific condition. See COUNTDISTINCTIF Function.
COUNT Function Generates the count of rows in the dataset. Gen= erated value is of Integer type.  See COUNT Function.
COUNTIF Function Generates the count of rows in each group that = meet a specific condition. Generated value is of Integer type.  See COUNTIF Function.
KTHLARGEST Function Extracts the ranked value from the values in a = column, where `k=3D1` returns the maximum value. The value for <= code>k must be between 1 and 1000, inclusive. See KTHLARGEST Function.
KTHLARGESTIF Function Extracts the ranked value from the values= in a column, where `k=3D1` returns the m= aximum value, when a specified condition is met. The value for = `k` must be between 1 and 1000, inclusive.  See KTHLARGESTIF Functio= n.
KTHLARGESTUNIQUE Function Extracts the ranked unique value from the value= s in a column, where `k=3D1` returns the maximum value. The valu= e for `k` must be between 1 and 1000, inclusive. See KTHLARGESTUNIQUE Function. =20
LIST Function Extracts the set of values from a column into a= n array stored in a new column. This function is typically part of an aggre= gation.  See LIST Function= .
LISTIF Function Returns list of all values in a column for rows= that match a specified condition. See LISTIF Function.
MAX Function Computes the maximum value found in all row val= ues in a column. Input column are permitted to be of Integer or Decimal. Se= e MAX Function.
MAXIF Function Generates the maximum value of rows in each gro= up that meet a specific condition. See MAXIF Function.
MIN Function Computes the minimum value found in all row val= ues in a column. Input column can be of Integer or Decimal. See MIN Function.
MINIF Function Generates the minimum value of rows in each gro= up that meet a specific condition. See MINIF Function.
MODE Function Computes the mode (most frequent value) from al= l row values in a column, according to their grouping. Input column can be = of Integer or Decimal type. See MOD= E Function.
MODEIF Function Computes the mode (most frequent value) from al= l row values in a column, according to their grouping. Input column can be = of Integer or Decimal type. See M= ODEIF Function.
STDEV Function Computes the standard deviation across all colu= mn values of Integer or Decimal type. See STDEV Function.
STDEVIF Function Generates the standard deviation of values by g= roup in a column that meet a specific condition. See STDEVIF Function.
SUM Function Computes the sum of all values found in all row= values in a column. Input column can be of Integer or Decimal. See SUM Function.
SUMIF Function Generates the sum of rows in each group that me= et a specific condition. See SUMIF= Function.
UNIQUE Function Extracts the set of unique values from a column= into an array stored in a new column. This function is typically part of a= n aggregation.  See UNIQUE F= unction.
VAR Function Computes the variance among all values in a col= umn. Input column can be of Integer or Decimal. If no numeric values a= re detected in the input column, the function returns `0`.&= nbsp; See VAR Function.
VARIF Function Generates the variance of values by group in a = column that meet a specific condition. See VARIF Function.
KTHLARGESTUNIQUEIF Function Extracts the ranked unique value from the value= s in a column, where `k=3D1` returns the maximum value= , when a specified condition is met. The value for `k` = ;must be between 1 and 1000, inclusive. Inputs can be Integer or Decimal. S= ee KTHLARGESTUNIQUEIF= Function.
=20

## Logical Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20
ItemDescription
Logical Operators Logical operators (and, or, not) enable you to = logically combine multiple expressions to evaluate a larger, more complex e= xpression whose output is `true` or `false. See Logical Operators. `
AND Function Returns `true` if both arg= uments evaluate to `true`. Equivalent to the ```&& operator. See AND Function.= ```
OR Function Returns `true` if either a= rgument evaluates to `true`. Equivalent to the `||` o= perator. See OR Function.
NOT Function Returns `true` if the argu= ment evaluates to `false`, and vice-versa. Equivalent to the ! operator. See NOT Functi= on.
=20

## Comparison Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
Comparison Operators Comparison operators enable you to compare valu= es in the left-hand side of an expression to the values in the right-hand s= ide of an expression. See Co= mparison Operators.
ISEVEN Function Returns `true` if the argu= ment is an even value. Argument can be an Integer, a function returning Int= egers, or a column reference. See ISEVEN Function.
ISODD Function Returns `true` if the argu= ment is an odd value. Argument can be an Integer, a function returning Inte= gers, or a column reference. See I= SODD Function.
IN Function Returns `true` if the firs= t parameter is contained in the array of values in the second parameter. Se= e IN Function.
MATCHES Function Returns `true` if a value contains a= string or pattern. The value to search can be a string literal or a refere= nce to a column of String type. See MATCHES Function.
EQUAL Function Returns `true` if the firs= t argument is equal to the second argument. Equivalent to the `=3D operator. See EQUAL Function. `
NOTEQUAL Function Returns `true` if the firs= t argument is not equal to the second argument. Equivalent to the ```<= ;>``` or `!=3D` operator. See NOTEQUAL Function.
GREATERTHAN Function Returns `true` if the firs= t argument is greater than but not equal to the second argument. Equivalent= to the `>` operator. See GREATERTHAN Function.
GREATERTHANEQUAL Function Returns `true` if the firs= t argument is greater than or equal to the second argument. Equivalent to t= he `>=3D` operator. See GREATERTHANEQUAL Function.
LESSTHAN Function Returns `true` if the firs= t argument is less than but not equal to the second argument. Equivalent to= the `<` operator. See LESSTHAN Function.
LESSTHANEQUAL Function Returns `true` if the firs= t argument is less than or equal to the second argument. Equivalent to the = `<=3D` operator. See LESSTHANEQUAL Function.
=20

## Math Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
Numeric Operators Numeric operators enable you to generate new va= lues based on a computation (e.g. `3 + 4`). See Numeric Operators.
NUMFORMAT Function Formats a numeric set of values according to th= e specified number formatting. Source values can be a reference to a column= containing Integer or Decimal values. See NUMFORMAT Function.
ADD Function Returns the value of summing the first argument= and the second argument. Equivalent to the `+` operator. See ADD Function.
SUBTRACT Function Returns the value of subtracting the second arg= ument from the first argument. Equivalent to the `-` operator. S= ee SUBTRACT Function.
MULTIPLY Function Returns the value of multiplying the first argu= ment by the second argument. Equivalent to the `*` operator. See= MULTIPLY Function.
DIVIDE Function Returns the value of dividing the first argumen= t by the second argument. Equivalent to the `/` operator. See DIVIDE Function.
MOD Function Returns the modulo value, which is the remainde= r of dividing the first argument by the second argument. Equivalent to the = `%` operator. See MOD Fun= ction.
NEGATE Function Returns the opposite of the value that is the f= irst argument. Equivalent to the `-` operator placed in front of= the argument. See NEGATE Functio= n.
SIGN Function Computes the positive or negative sign of a giv= en numeric value. The value can be a Decimal or Integer literal, a function= returning Decimal or Integer, or a reference to a column containing numeri= c values. See SIGN Function. =20
LCM Function Returns the least common multiple shared by the= first and second arguments. See LCM= Function.
ABS Function Computes the absolute value of a given numeric = value. The value can be a Decimal or Integer literal or a reference to a co= lumn containing numeric values. See = ABS Function.
EXP Function Computes the value of e raised to the = specified power. The value can be a Decimal or Integer literal or a referen= ce to a column containing numeric values. See EXP Function.
LOG Function Computes the logarithm of the first argument wi= th a base of the second argument. See LOG Function.
LN Function Computes the natural logarithm of an input valu= e. The value can be a Decimal or Integer literal or a reference to a column= containing numeric values. See LN Fu= nction.
POW Function Computes the value of the first argument = raised to the value of the second argument.  See POW Function.
SQRT Function Computes the square root of the input par= ameter.  Input value can be a Decimal or Intege= r literal or a reference to a column containing numeric values. All generated values are non-negative. See SQRT Function.
CEILING Function Computes the ceiling of a valu= e, which is the smallest integer that is greater than the input value. Inpu= t can be an Integer, a Decimal, a column reference, or an expression. See <= a href=3D"/display/r064/CEILING+Function">CEILING Function.
FLOOR Function Computes the largest integer that is not more t= han the input value. Input can be an Integer, a Decimal, a column refe= rence, or an expression.  See FLOOR Function.
ROUND Function Rounds input value to the nearest integer. = ;Input can be an Integer, a Decimal, a column reference, or an express= ion. Optional second argument can be used to specify the number of dig= its to which to round. See ROUND F= unction.
TRUNC Function Removes all digits to the right of the decimal = point for any value. Optionally, you can specify the number of digits to wh= ich to round. Input can be an Integer, a Decimal, a column reference, = or an expression.  See TRUNC = Function.
RADIANS Function Computes the radians of an input value measurin= g degrees of an angle. The value can be a Decimal or Integer literal or a r= eference to a column containing numeric values. See RADIANS Function.
DEGREES Function Computes the degrees of an input value measurin= g the radians of an angle. The value can be a Decimal or Integer literal or= a reference to a column containing numeric values. See DEGREES Function.
=20

## Date Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
DATE Function Generates a date value from three inputs of Int= eger type: year, month, and day. See DATE Function.
TIME Function Generates time values from three inputs of Inte= ger type: hour, minute, and second. See TIME Function.
DATETIME Function Generates a Datetime value from the following i= nputs of Integer type: year, month, day, hour, minute, and second. See DATETIME Function.
DATEADD Function Add a specified number of units to a valid date= . Units can be any supported Datetime unit (e.g. `minute`, month, `year`, etc.). Input must be a column reference c= ontaining dates. See DATEADD Fun= ction.
DATEDIF Function Calculates the difference between two valid dat= e values for the specified units of measure. See DATEDIF Function.
DATEFORMAT Function Formats a specified Datetime set of values acco= rding to the specified date format. Source values can be a reference to a c= olumn containing Datetime values. See DATEFORMAT Function.
UNIXTIMEFORMAT Function Formats a set of Unix timestamps according to a= specified date formatting string. See UNIXTIMEFORMAT Function.
MONTH Function Derives the month integer value from a Datetime= value. Source value can be a a reference to a column containing Datetime v= alues or a literal. See MONTH Func= tion.
MONTHNAME Function Derives the full name from a Datetime value as = a String. Source value can be a reference to a column containing Datetime v= alues or a literal. See MONTHN= AME Function.
YEAR Function Derives the four-digit year value from a Dateti= me value. Source value can be a a reference to a column containing Datetime= values or a literal. See YEAR Func= tion.
DAY Function Derives the numeric day value from a Datetime v= alue. Source value can be a a reference to a column containing Datetime val= ues or a literal. See DAY Function.
WEEKNUM Function Derives the numeric value for the week within t= he year (`1`, `2`, etc.). Input must be the output of= the `DATE` function or a reference to a column containing Datet= ime values. The output of this function increments on Sunday. See WEEKNUM Function.
WEEKDAY Function Derives the numeric value for the day of the we= ek (`1`, `2`, etc.). Input must be a reference to a c= olumn containing Datetime values. See WEEKDAY Function.
HOUR Function Derives the hour value from a Datetime value. G= enerated hours are expressed according to the 24-hour clock. See HOUR Function.
MINUTE Function Derives the minutes value from a Datetime value= . Minutes are expressed as integers from 0 to 59. See MINUTE Function.
SECOND Function Derives the seconds value from a Datetime value= . Source value can be a a reference to a column containing Datetime values = or a literal. See SECOND Function= .
UNIXTIME Function Derives the Unixtime (or epoch time) value from a Datetime value. Source value can be a reference to a column= containing Datetime values. See UNIXTIME Function.
NOW Function Derives the timestamp for the= current time in UTC time zone. You can specify a differ= ent time zone by optional parameter.
See NOW Function.
TODAY Function Derives the value for the current date in UTC time zone. You can specify a different time z= one by optional parameter. See TOD= AY Function.
PARSEDATE Function Evaluates an input against an array of Datetime= format strings in their listed order. If the input matches one of the list= ed formats, the function outputs a Datetime value. See PARSEDATE Function.
=20

## String Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
CHAR Function Generates the Unicode character corresponding t= o an inputted Integer value.  See CHAR Function.
UNICODE Function Generates the Unicode index value for the first= character of the input string. See UNICODE Function.
UPPER Function All alphabetical characters in the input value = are converted to uppercase in the output value. See UPPER Function.
LOWER Function All alphabetical characters in the input value = are converted to lowercase in the output value. See LOWER Function.
PROPER Function Converts an input string to propercase. In= put can be a column reference or a string literal. See PROPER Function.
TRIM Function Removes leading and trailing whitespace from a = string. Spacing between words is not removed. See TRIM Function.
REMOVEWHITESPACE Function Removes all whitespace from a string, including= leading and trailing whitespace and all whitespace within the string. See = REMOVEWHITESPACE Functi= on.
REMOVESYMBOLS Function Removes all characters from a string that are n= ot letters, numbers, accented Latin characters, or whitespace. See REMOVESYMBOLS Function.
LEN Function Returns the number of characters in a specified= string. String value can be a column reference or string literal. See LEN Function.
FIND Function Returns the index value in the input string whe= re a specified matching string is located. Search is conducted left-to-righ= t. See FIND Function.
RIGHTFIND Function Returns the index value in the input string whe= re the last instance of a matching string is located. Search is conducted r= ight-to-left. See RIGHTFIND Fu= nction.
SUBSTRING Function Matches some or all of a string, based on the u= ser-defined starting and ending index values within the string. See SUBSTRING Function.
SUBSTITUTE Function Replaces found string literal or pattern from a= source with a string. See SU= BSTITUTE Function.
LEFT Function Matches the leftmost set of characters in a str= ing, as specified by parameter. The string can be specified as a column ref= erence or a string literal. See LEF= T Function.
RIGHT Function Matches the right set of characters in a string= , as specified by parameter. The string can be specified as a column refere= nce or a string literal. See RIGHT= Function.
PAD Function Pads string values to be a specified minimum le= ngth by adding a designated character to the left or right end of the strin= g. Returned value is of String type. See PAD Function.
MERGE Function Merges two or more columns of String type= to generate output of String type. Optionally, you can insert a delimiter = between the merged values. See MERGE Function.
STARTSWITH Function Returns `true` if the leftmost= set of characters of a column of values matches a pattern. The sour= ce value can be any data type, and the pattern can be a Trifacta pattern, regular expression, or a string. See <= a href=3D"/display/r064/STARTSWITH+Function">STARTSWITH Function.
ENDSWITH Function Returns `true` = if the rightmost set of characters of a column of values matc= hes a pattern. The source value can be any data type, and the patter= n can be a Trifacta pattern, regular = expression, or a string. See EN= DSWITH Function.
REPEAT Function Repeats a string a specified number of times. T= he string can be specified as a String literal, a function returning a Stri= ng, or a column reference. See RE= PEAT Function.
EXACT Function Returns `true` if the second s= tring evaluates to be an exact match of the first string. Source values can= be string literals, column references, or expressions that evaluate to str= ings. See EXACT Function.
STRINGGREATERTHAN Function Returns `true` if the first st= ring evaluates to be greater than the second string, based on a set of comm= on collation rules. See STRINGGREATERTHAN Function.
STRINGGREATERTHANEQUAL Function Returns `true` if the first st= ring evaluates to be greater than or equal to the second string, based on a= set of common collation rules. See STRINGGREATERTHANEQUAL Function.
STRINGLESSTHAN Function Returns `true` if the first st= ring evaluates to be less than the second string, based on a set of common = collation rules. See STRINGLESSTHAN Function.
STRINGLESSTHANEQUAL Function Returns `true` if the first st= ring evaluates to be less than or equal to the second string, based on a se= t of common collation rules. See STRINGLESSTHANEQUAL Function.
DOUBLEMETAPHONE Function Returns a two-element array of primary an= d secondary phonetic encodings for an input string, based on the Double Met= aphone algorithm. See DOUBLEMETAPHONE Function.
DOUBLEMETAPHONEEQUALS Function Compares two input strings using the Doub= le Metaphone algorithm. An optional threshold parameter can be modified to = adjust the tolerance for matching. See DOUBLEMETAPHONEEQUALS Function.
TRANSLITERATE Function Transliterates Asian script characters from one= script form to another. The string can be specified as a column reference = or a string literal. See T= RANSLITERATE Function.
=20

## Nested Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
ARRAYCONCAT Function Combines the elements of one array with another= , listing all elements of the first array before listing all elements of th= e second array. See ARRAYCON= CAT Function.
ARRAYCROSS Function Generates a nested array containing the cross-p= roduct of all elements in two or more arrays. See ARRAYCROSS Function.
ARRAYELEMENTAT Function Computes the 0-based index value for an array e= lement in the specified column, array literal, or function that returns an = array. See ARRAYELEMENTAT= Function.
ARRAYINDEXOF Function Computes the index at which a specified element= is first found within an array. Indexing is left to right. See ARRAYINDEXOF Function.
ARRAYINTERSECT Function Generates an array containing all elements that= appear in multiple input arrays, referenced as column names or array liter= als. See ARRAYINTERSECT F= unction.
ARRAYLEN Function Computes the number of elements in the arrays i= n the specified column, array literal, or function that returns an array. S= ee ARRAYLEN Function.
ARRAYMERGEELEMENTS Function Merges the elements of an array in left to righ= t order into a string. Values are optionally delimited by a provided delimi= ter. See ARRAYMERGEEL= EMENTS Function.
ARRAYRIGHTINDEXOF Function Computes the index at which a specified element= is first found within an array, when searching right to left. Returned val= ue is based on left-to-right indexing. See ARRAYRIGHTINDEXOF Function.
ARRAYSLICE Function Returns an array containing a slice of the inpu= t array, as determined by starting and ending index parameters. See ARRAYSLICE Function.
ARRAYSORT Function Sorts array values in the specified column, arr= ay literal, or function that returns an array in ascending or descending or= der. See ARRAYSORT Function.
ARRAYSTOMAP Function Combines one array containing keys and another = array containing values into an Object of key-value pairs. See ARRAYSTOMAP Function.
ARRAYUNIQUE Function Generates an array of all unique elements among= one or more arrays. See ARR= AYUNIQUE Function.
ARRAYZIP Function Combines multiple arrays into a single nested a= rray, with element 1 of array 1 paired with element 2 of array 2 and so on.= Arrays are expressed as column names or as array literals. See ARRAYZIP Function.
FILTEROBJECT Function Filters the keys and values from an Object data= type column based on a specified key value. See FILTEROBJECT Function.
KEYS Function Extracts the key values from an Object data typ= e column and stores them in an array of String values. See KEYS Function.
LISTAVERAGE Function Computes the average of all numeric values foun= d in input array. Input can be an array literal, a column of arrays, or a f= unction returning an array. Input values must be of Integer or Decimal type= . See LISTAVERAGE Function.
LISTMAX Function Computes the maximum of all numeric values foun= d in input array. Input can be an array literal, a column of arrays, or a f= unction returning an array. Input values must be of Integer or Decimal type= . See LISTMAX Function. =20
LISTMIN Function Computes the minimum of all numeric values foun= d in input array. Input can be an array literal, a column of arrays, or a f= unction returning an array. Input values must be of Integer or Decimal type= . See LISTMIN Function. =20
LISTMODE Function Computes the most common value of all numeric v= alues found in input array. Input can be an array literal, a column of arra= ys, or a function returning an array. Input values must be of Integer or De= cimal type. See LISTMODE Functi= on.
LISTSTDEV Function Computes the standard deviation of all numeric = values found in input array. Input can be an array literal, a column of arr= ays, or a function returning an array. Input values must be of Integer or D= ecimal type. See LISTSTDEV Fun= ction.
LISTSUM Function Computes the sum of all numeric values found in= input array. Input can be an array literal, a column of arrays, or a funct= ion returning an array. Input values must be of Integer or Decimal type. Se= e LISTSUM Function.
LISTVAR Function Computes the variance of all numeric values fou= nd in input array. Input can be an array literal, a column of arrays, or a = function returning an array. Input values must be of Integer or Decimal typ= e. See LISTVAR Function. =20
=20

## Type Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
NULL Function The `NULL` function genera= tes null values. See NULL Function<= /a>.
IFNULL Function The `IFNULL` function writ= es out a specified value if the source value is a null. Otherwise, it write= s the source value. Input can be a literal, a column reference, or a functi= on. See IFNULL Function. =20
IFMISSING Function The `IFMISSING` function w= rites out a specified value if the source value is a null or missing value.= Otherwise, it writes the source value. Input can be a literal, a column re= ference, or a function. See IF= MISSING Function.
IFMISMATCHED Function The `IFMISMATCHED` functio= n writes out a specified value if the input expression does not match the s= pecified data type or typing array. Otherwise, it writes the source value. = Input can be a literal, a column reference, or a function. See IFMISMATCHED Function.
IFVALID Function The `IFVALID` function wri= tes out a specified value if the input expression matches the specified dat= a type. Otherwise, it writes the source value. Input can be a literal, a co= lumn reference, or a function. See IFVALID Function.
ISNULL Function The `ISNULL` function tests whether = a column of values contains null values. For input column references, this = function returns `true` or `false`. See ISNULL Function.
ISMISSING Function The `ISMISSING` function tests wheth= er a column of values is missing or null. For input column references, this= function returns `true` or `false`. See ISMISSING Function.
ISMISMATCHED Function Tests whether a set of values is not valid for = a specified data type. See = ISMISMATCHED Function.
VALID Function Tests whether a set of values is valid for a sp= ecified data type and is not a null value. See VALID Function.
=20

## Window Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
PREV Function Extracts the value from a column that is a spec= ified number of rows before the current value. See PREV Function.
NEXT Function Extracts the value from a column that is a spec= ified number of rows after the current value. See NEXT Function.
FILL Function Fills any missing or null values in the specifi= ed column with the most recent non-blank value, as determined by the s= pecified window of rows before and after the blank value. See FILL Function.
ROLLINGAVERAGE Function Computes the rolling average of values forward = or backward of the current row within the specified column. See ROLLINGAVERAGE Function.
ROLLINGMODE Function Computes the rolling mode (most common value) f= orward or backward of the current row within the specified column. See ROLLINGMODE Function.
ROLLINGMAX Function Computes the rolling maximum of values forward = or backward of the current row within the specified column. See ROLLINGMAX Function.
ROLLINGMIN Function Computes the rolling minimum of values forward = or backward of the current row within the specified column. See ROLLINGMIN Function.
ROLLINGSUM Function Computes the rolling sum of values forward or b= ackward of the current row within the specified column. See ROLLINGSUM Function.
ROLLINGSTDEV Function Computes the rolling standard deviation of valu= es forward or backward of the current row within the specified column. See = ROLLINGSTDEV Function. =
ROLLINGVAR Function Computes the rolling variance of values forward= or backward of the current row within the specified column. See ROLLINGVAR Function.
ROLLINGCOUNTA Function Computes the rolling count of non-null values f= orward or backward of the current row within the specified column. See ROLLINGCOUNTA Function. =20
ROLLINGKTHLARGEST Function Computes the rolling kth largest value= forward or backward of the current row. See ROLLINGKTHLARGEST Function.
ROLLINGKTHLARGESTUNIQUE Function Computes the rolling unique kth larges= t value forward or backward of the current row. See ROLLINGKTHLARGESTUNIQUE Function. <= /td>=20
ROLLINGLIST Function Computes the rolling list of values forward or = backward of the current row within the specified column and returns an arra= y of these values. See ROLLI= NGLIST Function.
ROWNUMBER Function Generates a new column containing the row numbe= r as sorted by the `order` parameter and optionally grouped by t= he `group` parameter. See ROWNUMBER Function.
SESSION Function Generates a new session identifier based on a s= orted column of timestamps and a specified rolling timeframe. See SESSION Function.
RANK Function Computes the rank of an ordered set of value wi= thin groups. Tie values are assigned the same rank, and the next ranking is= incremented by the number of tie values. See RANK Function.
DENSERANK Function Computes the rank of an ordered set of va= lue within groups. Tie values are assigned the same rank, and the ne= xt ranking is incremented by 1. See DENSERANK Function.
=20

## Other Functions

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
ItemDescription
COALESCE Function Function returns the first non-missing value fo= und in an array of columns. See COALESCE Function.
RAND Function The `RAND` function genera= tes a random real number between 0 and 1. The function accepts an opti= onal integer parameter, which causes the same set of random numbers to be g= enerated with each job execution. See RAND Function.
RANDBETWEEN Function Generates a random integer between a low and a = high number. Two inputs may be Integer or Decimal types, functions ret= urning these types, or column references. See RANDBETWEEN Function.
PI Function The `PI` function generate= s the value of pi to 15 decimal places: 3.1415926535897932. See PI Function.
SOURCEROWNUMBER Function Returns the row number of the current row as it= appeared in the original source dataset before any steps had been applied.= See SOURCEROWNUMBER Fun= ction.
IF Function The `IF` function= allows you to build if/then/else conditional logic within your transforms.= See IF Function.
CASE Function The `CASE` functi= on allows you to perform multiple conditional tests on a set of expressions= within a single statement. When a test evaluates to `true`, a c= orresponding output is generated. Outputs may be a literal or expression. See CASE Function.
Ternary Operators Ternary operators allow you to build if/then/el= se conditional logic within your transforms. Please use the `IF`= function instead. See Ternary = Operators.
IPTOINT Function Computes an integer value for a four-octet inte= rnet protocol (IP) address. Source value must be a valid IP address or a co= lumn reference to IP addresses. See IPTOINT Function.
IPFROMINT Function Computes a four-octet internet protocol (IP) ad= dress from a 32-bit integer input. See IPFROMINT Function.
RANGE Function Computes an array of integers, from a beginning= integer to an end (stop) integer, stepping by a third parameter. See RANGE Function.
HOST Function Finds the host value from a valid URL. Input va= lues must be of URL or String type and can be literals or column references= . See HOST Function.
DOMAIN Function Finds the value for the domain from a valid URL= . Input values must be of URL or String type. See DOMAIN Function.
SUBDOMAIN Function Finds the value a subdomain value from a valid = URL. Input values must be of URL or String type. See SUBDOMAIN Function.
SUFFIX Function Finds the suffix value after the domain from a = valid URL. Input values must be of URL or String type. See SUFFIX Function.
URLPARAMS Function Extracts the query parameters of a URL into an = Object. The Object keys are the parameter's names, and its values are the p= arameter's values. Input values must be of URL or String type. See URLPARAMS Function.
=20

------=_Part_27188_6555984.1627564862149--