Combine sheets by row

Combine sheets by row stacks multiple CSV files into a single file, appending rows from each input file in order. All combined files must share the same header row.

Availability: GA

What it does

Input: one or more CSV lists.
Output: a single combined CSV file containing every row from every input file, using one shared header row.

When to use it

You receive daily or per-region files that need to be merged into one file before validation or delivery.
A Split or Split CSV into multiple sheets transform earlier in the MFF needs to be reassembled later.
You want a single file for a downstream delivery target that only accepts one file per run.

How to configure it

In the MFF builder, add a Combine sheets by row node after the node that produces the list of CSVs you want to merge.

Settings

Setting	Description	Default
Output file name	The file name given to the combined output file.	`combined_rows.csv`

Example

Input

Three CSV files, west.csv, east.csv, and central.csv, each with the columns Region, Rep, Amount.

Output

A single file, combined_rows.csv, containing all rows from the three input files under one header row.

Troubleshooting

Error about mismatched headers

Combine sheets by row requires every input file to have identical column headers, including order. Use a Rename transform upstream to align column names before combining.

Some rows appear to be missing

Confirm every expected file is present in the incoming list. If an upstream filter or split transform dropped a file, it will not appear in the combined output.