The table summarizes the tabular operators functions available in APL.

FunctionDescription
countReturns an integer representing the total number of records in the dataset.
distinctReturns a dataset with unique values from the specified fields, removing any duplicate entries.
extendReturns the original dataset with one or more new fields appended, based on the defined expressions.
extend-validReturns a table where the specified fields are extended with new values based on the given expression for valid rows.
limitReturns the top N rows from the input dataset.
orderReturns the input dataset, sorted according to the specified fields and order.
parseReturns the input dataset with new fields added based on the specified parsing pattern.
projectReturns a dataset containing only the specified fields.
project-awayReturns the input dataset excluding the specified fields.
project-keepReturns a dataset with only the specified fields.
project-reorderReturns a table with the specified fields reordered as requested followed by any unspecified fields in their original order.
sampleReturns a table containing the specified number of rows, selected randomly from the input dataset.
searchReturns all rows where the specified keyword appears in any field.
sortReturns a table with rows ordered based on the specified fields.
summarizeReturns a table where each row represents a unique combination of values from the by fields, with the aggregated results calculated for the other fields.
takeReturns the specified number of rows from the dataset.
topReturns the top N rows from the dataset based on the specified sorting criteria.
unionReturns all rows from the specified tables or queries.
whereReturns a filtered dataset containing only the rows where the condition evaluates to true.