Skip to content

Creating or loading tables

These functions 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.

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