CSV File Splitter¶
The CSV File Splitter plugin splits an incoming CSV file into one or more output files.
The default behavior is to write each record of the incoming file to a separate output file. By defining one or more primary keys you can group the incoming records, so that all records with the same primary key values are written to the same output file.
This plugin can be associated only with Private Agent Groups and is not available on the Jitterbit Cloud Agent Groups.
Plugins provided by Jitterbit are deprecated. See Deprecation and Support in Plugins.
Download and Add the Plugin¶
The CSV File Splitter plugin must be downloaded at the link provided below and added to the organization (see Add New Plugins in Customizations > Plug-ins).
Associate the Plugin with an Agent Group¶
The CSV File Splitter plugin must be associated with a Private Agent Group to make the plugin available on all agents in the group (see Associate Agent Groups in Customizations > Plug-ins).
Set Variables and Use the Plugin in a Project¶
Refer to these topics for information about using plugins in a project:
The CSV File Splitter plugin uses these variables:
| ||String||Optional||The field delimiter. The default value is |
| ||String||Optional||The value qualifier. The default value is |
| ||String||Optional|| |
Defines the field(s) to use as primary key(s) when splitting up the input file.
If defined, all records of the input file having the same primary key value(s) will be written to the same output file. If defined, this value should be a comma-separated list of field indices, the first field having index 1.
For example, if the incoming file has 3 fields: