Creating or loading tables

Autory has many custom functions for creating or loading tables. They have the following in common:

• They create or load a table from somewhere.
• They ensure that the table exists in the output and can therefore be referenced by formulas.
• They return the table name. This may be different from the original table name.
• They allow SQL queries to be performed on the table. See SQL queries.
• They allow per-column data type detection / conversion to be performed on the table. See data types.

The functions are:

• csvToTable
• featherToTable
• excelTable
• projectionResultsToTable
• resultsJsonToTable
• sqlToTable
• table

Any one of these functions may be used anywhere that a table name is expected (e.g. TableLookup or tableSumIfs). They may also be used on their own to simply ensure that the table exists in the output.