Dynamic split: one file → many files by one column

Integrator.io
1

Required behavior

  1. Read the single file (e.g. from SFTP).

  2. Group / split records by the Company Code column (dynamic number of companies — not a fixed list).

  3. Write one output file per distinct company code, each containing only that company’s rows.

  4. Output file naming: each file name should start with the company code, e.g.
    {company_code}_data...

What we’ve looked at
We explored standard FTP/SFTP import options, batching, and handlebars-style file names. We need confirmation of the recommended pattern in integrator.io for dynamic N companies → N files when N is not known in advance.

Questions

  1. Is there a built-in or documented way to achieve dynamic split-by-column → multiple SFTP files with the naming pattern above?

  2. If not native, what is Celigo’s recommended approach (e.g. preSavePage / postResponseMap, import settings, or hybrid with HTTP/external processor)?

  3. Any limitations we should plan for (batching, aggregation, filename collisions, page size)?

2

Set page size = 1 on the export, then on import use "One file per page of records".