CSV File Splitter¶

Introduction¶

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.

Important

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).

CSV File Splitter (.ZIP)

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:

Plugins (Cloud Studio)
Plugins (Design Studio)

The CSV File Splitter plugin uses these variables:

Name Type Required Description

Jitterbit.CsvFileSplitter.Delimiter String Optional The field delimiter. The default value is ','.

Jitterbit.CsvFileSplitter.Qualifier String Optional The value qualifier. The default value is '"'.

Jitterbit.CsvFileSplitter.PrimaryKeys

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: "order_id, order_date, comment", and you want all records with the same order ID to be written to the same output file, the value of this variable should be "1". If you want to use the order date as a primary key as well you should set this data element to "1, 2".