Skip to main content

Advanced functions

This section describes advanced functions that are not in the Function Builder. To use them, type ATL directly into the script editor.

If you run into difficulties with these functions, please don’t hesitate to contact us at Support.

Index of advanced functions

asJson	Converts a JSON string to a JSON object.
filter	Filters a list or list-like object.
filterRows	Filters a table or table region.
forAll	Loops through a list (or array) and applies a function to all items.
forAllCellsByColumn	Loops through a column and applies a function to all cell values.
forAllCellsByRow	Loops through a row and applies a function to all cell values.
forAllColumns	Loops through all columns and applies a function to all cell values.
forAllRows	Loops through all rows and applies a function to all cell values.
groupByJson	Groups JSON arrays with matching values in one or more fields. For each group, the function then aggregates the data for one or more fields.
groupByJsonObject	Groups JSON objects with matching values in one or more fields. For each group, the function then aggregates the data for one or more fields.
groupByVarianceJson	Calculates the variance between the sum-aggregated values for two measures (base and comparison), then breaks the variance down by one or more grouping dimensions.
groupByVarianceTable	Calculates the variance between the sum-aggregated values for two measures (base and comparison), then breaks the variance down by one or more grouping dimensions.
isEmpty	Tests if a string, list, table cell, or JSON object is empty.
isNotEmpty	Tests if a string, list, table cell, or JSON object is not empty.
makeList	Makes a data list from zero or more values.
map	Loops through a list, applies a function to each value, and returns a new list.
mapRows	Loops through rows in a table or table region, applies a mapping function to the values in one or more columns, and returns the amended table.
numColumns	Returns the number of columns in your table.
numRows	Returns the number of rows in your table.
pairwiseMap	Pairs values from two lists, applies a function to each pairing, and returns a new list of values.
reduce	Reduces a list of values to a single value.
sort	Sorts a list or list-like object such as a JSON array.
sortByColumn	Sorts a table region by the values in one column.
sortByColumnNumbers	Sorts a table region by a single column's values in ascending order.
sortByColumnNumbersReverse	Sorts a table region by a single column's values in descending order.
sortByColumnStrings	Sorts a table region by a single column's values in alphabetical order.
sortByColumnStringsReverse	Sorts a table region by a single column's values in reverse-alphabetical order.
sortByRow	Sorts a table region by the values in one row.
sortByRowNumbers	Sorts a table region by a single row's values in ascending order.
sortByRowNumbersReverse	Sorts a table region by a single row's values in descending order.
sortByRowStrings	Sorts a table region by a single row's values in alphabetical order.
sortByRowStringsReverse	Sorts a table region by a single row's values in reverse-alphabetical order.
sortDateTimes	See description in the Datetime Functions index.
sortDateTimesReverse	See description in the Datetime Functions index.
sortNumbers	Sorts numeric values in ascending order.
sortNumbersReverse	Sorts numeric values in descending order.
sortStrings	Sorts string values in alphabetical order.
sortStringsReverse	Sorts string values in reverse-alphabetical order.
top	Returns the top N values from the input data.
topColumns	Returns the top N columns in a table region.
topRows	Returns the top N rows in a table region.
zip	Pairs values from two lists and returns a list of pairs.
zipWithIndex	Takes a list, pairs each value with its index number, and returns a list of pairs.