Create Tables
A table is a set of values indexed by name. You can define a table in the UI and on the language.
Units of columns
Here, each column is a list with the same length. As with lists, you can specify the units of a given column:
Columns with ranges
You can also declare a column like this:
Columns with calculations
Instead of manually inputting values, each column's cell can be based on the outputs of other cells:
Using columns as a whole
Sometimes, when deriving a column from another with an expression, you might want to use the whole column at once instead of doing your calculations on a row-by-row basis. Like when you want to know the maximum of a column:
Or analyze changes to your profits:
Using previous values
You can access previous column values by using the word previous and providing a value for the first cell, like this:
Access columns
You can access the table columns individually:
You can then use them as lists:
Even inside your table, you can refer to its previous columns, if you need to aggregate them.
Add columns
Add new columns to a defined table with . followed by their name. Their sizes must match the existing table columns.
Index column
You can use the first column as an index for the row by using cells of text:
When you extract a column, it remembers the original index:
You can still do operations on that column, and it will still remember the original index:
Augmenting tables
If you have a table, you can copy it to another table using the ... sign:
Now you can add some columns of their own:
Re-using columns
If you want to display just the flight number and AccumulatedPassengerCount you can:
This allows you to further augment the table without listing every previously computed value.