Combine Delimited Files

Use the Combine Delimited Files flow step to combine two or more delimited files into a single delimited file. This step is commonly preceded by one or more Lookup steps to fetch the data. It is commonly followed by a Connector Action step to send the combined file to its destination.

Step Inputs

Start by creating a new step, choosing an appropriate name for it, and choosing Combine Delimited Files as the Type. The following step-specific fields will appear:

File API

Choose File API unless you know for certain your delimited files were uploaded through the Legacy File API. This field is required.

File IDs

Enter the IDs of the files you want to combine, separated by commas (no space), and in the order you want the data to be merged. For example: file1,file2,file3. You can find the ID of a specific file using the Workspace Cache Explorer.

File Name

Enter the name of the combined file you will create. This can be static or dynamic, based on available data (e.g. date, flow/step data, etc.)

Note: Although this field is not required, you are highly encouraged to specify a name. Failing to do so could lead to unexpected behavior.

Has Header Row

Enable this if the files you are combining have header rows. The header rows will be preserved in the combined file.

Line Ending

Enter your preferred line ending format: Unix (LF) or Windows (CRLF). If you are unsure or have no preference, leave the value as Unspecified.

Step Outputs

The Combine Delimited Files flow step outputs a URL pointer for accessing your new combined delimited file. The output file exists in your Workspace Cache and has the name you entered in the File Name field. It includes the data from all the source files combined in the specified order. The header rows will be preserved if you configured the step to include headers.