bulk_aggregate_multi_files
Aggregate data from the same column across multiple Excel or CSV files in parallel using operations like sum, average, count, min, or max. Process multiple files simultaneously to consolidate results or view per-file breakdowns.
Instructions
Aggregate same column across multiple files in parallel
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePaths | Yes | Array of file paths to process | |
| column | Yes | Column name or index (0-based) to aggregate | |
| operation | Yes | Aggregation operation | |
| consolidate | No | Whether to return consolidated result or per-file breakdown (default: true) | |
| sheet | No | Sheet name for Excel files (optional) | |
| filters | No | Optional filters to apply before aggregation |