Formulas for tables

Built-in functions that operate on tables:

lookup

Here is documentation on the lookup function.

select

You can use the select directive to pick some columns from your table, and create a smaller table.

sortby

This formula sorts a table by the values of a column:

splitby

This formula splits the table into several different tables, split by the unique values of a column:

reverse

This formula reverses a table:

filter

You can select the elements from a table based on a condition: