union_tables
Combine matching worksheet or table data from multiple Excel workbook files into one dataset for cross-file analysis.
Instructions
Union comparable worksheet or table data across multiple workbook files.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"filepaths": "<filepaths>"
},
"name": "union_tables"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| select | No | ||
| sort_by | No | ||
| row_mode | No | arrays | |
| dedupe_on | No | ||
| filepaths | Yes | ||
| sort_desc | No | ||
| header_row | No | ||
| sheet_name | No | ||
| table_name | No | ||
| schema_mode | No | strict | |
| infer_schema | No | ||
| source_sample_limit | No | ||
| include_source_columns | No |