Combine Delimited Files Flow Step

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

In the Edit Step menu, you can add details about the step configuration as needed for your flow.

• File API: Choose either File API or Legacy File API depending on the method you use to access files. Most users should choose File API.

• 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 want to 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.

Was this helpful? Give us feedback.