Tabular operators

This section explains how to use and combine tabular operators in APL.

The table summarizes the tabular operators available in APL.

Function	Description
count	Returns an integer representing the total number of records in the dataset.
distinct	Returns a dataset with unique values from the specified fields, removing any duplicate entries.
extend	Returns the original dataset with one or more new fields appended, based on the defined expressions.
extend-valid	Returns a table where the specified fields are extended with new values based on the given expression for valid rows.
externaldata	Returns a table with the specified schema, containing data retrieved from an external source.
getschema	Returns the schema of a dataset, including field names and their data types
join	Returns a dataset containing rows from two different tables based on conditions.
limit	Returns the top N rows from the input dataset.
lookup	Returns a dataset where rows from one dataset are enriched with matching columns from a lookup table based on conditions.
make-series	Returns a dataset where the specified field is aggregated into a time series.
mv-expand	Returns a dataset where the specified field is expanded into multiple rows.
order	Returns the input dataset, sorted according to the specified fields and order.
parse	Returns the input dataset with new fields added based on the specified parsing pattern.
parse-kv	Returns a dataset where key-value pairs are extracted from a string field into individual columns.
parse-where	Returns a dataset where values from a string are extracted based on a pattern.
project	Returns a dataset containing only the specified fields.
project-away	Returns the input dataset excluding the specified fields.
project-keep	Returns a dataset with only the specified fields.
project-rename	Returns a dataset where the specified field is renamed according to the specified pattern.
project-reorder	Returns a table with the specified fields reordered as requested followed by any unspecified fields in their original order.
redact	Returns the input dataset with sensitive data replaced or hashed.
sample	Returns a table containing the specified number of rows, selected randomly from the input dataset.
search	Returns all rows where the specified keyword appears in any field.
sort	Returns a table with rows ordered based on the specified fields.
summarize	Returns a table where each row represents a unique combination of values from the by fields, with the aggregated results calculated for the other fields.
take	Returns the specified number of rows from the dataset.
top	Returns the top N rows from the dataset based on the specified sorting criteria.
union	Returns all rows from the specified tables or queries.
where	Returns a filtered dataset containing only the rows where the condition evaluates to true.