CSV Splitter splits CSV files into multiple files, each containing the common header and “n” number of data rows. The user can specify the number of rows per file, and a unique suffix (appended with an appropriately padded number).
An external XML metadata set with the Input CSV file information is generated and attached to each split file.
Especially useful where large CSV files, used in flows, fail with processing errors.
CSV Splitter only accepts CSV files from one or many incoming connections. The CSV input file must pass a simple validation, requiring a non-empty file, minimum of 2 rows, and no empty header row values (validation error files are logged and sent to the Error connection). Files that need no splits are simply passed to the Success connection.