autory run multiple
Usage: [OPTIONS] [PATHS]...
Run all Autory models as specified in the given config files.
PATHS: Names or paths of workbooks. Each workbook must have a table called
`RunMultipleRuns`, which defines the Autory models to run.
Options:
--parallel INTEGER The number of models to run in parallel. This
overrides the `parallel` option from the
`RunMultipleOptions` tables in the input files.
--vba-engine-dir DIRECTORY The folder containing `autory.xlsm` (the VBA
engine). Instead of detecting the path to the
VBA autory engine automatically, use the given
path. For advanced users and developers only.
--run-control, --rc TEXT Override one or more run control options for all
models.
--data-table TEXT Add data table(s) to the model(s) before running
them. See detailed help below.
--help Show this message and exit.
--------
Adding or overriding data tables:
`--data-table` may be specified multiple times to add multiple data
tables.
Each data table is specified as a comma-separated list of options, with
the following options available:
- `name`: The name of the data table to add in the model. This is
required.
- `src_file`: The path to the source file containing the data table.
This is required.
- `src_type`: The type of the source file. The supported types are
`feather`, `excel`, `csv`. If omitted, the type is inferred from the
file extension if possible.
- `src_table`: For files that contain multiple data tables (like
Excel workbooks), this specifies the name of the table to load.
- `existing`: What to do if a data table with the same name already
exists in the model.
- `replace`: Replace the existing data table with the new one.
(This is the default.)
- `skip`: Skip adding the new data table if one with the same
name already exists.
- `error`: Raise an error if a data table with the same name
already exists in the model.
The `--data-table` option reuses the logic from one of these functions,
depending on `src_type`:
- `feather`: See https://autory.autoactuary.com/functions/table-
create-load/feather-to-table.html
- `excel`: See https://autory.autoactuary.com/functions/table-
create-load/excel-table.html
- `csv`: See https://autory.autoactuary.com/functions/table-create-
load/csv-to-table.html
Examples:
- Load the contents of a CSV file into a data table called `Table1`:
`--data-table name=Table1,src_file=file.csv`
- Load the contents of `Table2` from an Excel workbook into a data table
called `Table1` in the model:
`--data-table name=Table1,src_file=file.xlsx,src_table=Table2`