Create Delimited File

Overview

The Create Delimited File step creates a file from tabular data. Commonly this step is preceded by a Lookup step or parse step to get the data and followed by a Post to Network App step to send the file to its destination. The output of the step is a pointer which includes the file’s ID as well as a URL for accessing it.

Using the Create Delimited File Step

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

Filename (required)

The name of the file you are creating. This can be static or dynamic, based on available data (e.g. date, flow/step data, etc.)

Include Header Row

Turn this on to include a header row of your column names.

Column Separator

Choose the character used to separate your values into columns (Comma, Hyphen, Pipe, or Tab).

Line Ending

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

Row Map

Enter an expression that evaluates to a list of JSON objects that define the data for your rows. This could be data from a previous Lookup or parse step.

Column Names

Specify the columns for your data. Entries can be added by clicking the :plus_icon: button and removed by clicking the :trash_icon: button. Note that the order of the entries will be the order the columns appear in your file. Each entry consists of two fields:

Column Name

The name of the column. This can be static or dynamic, based on available data (e.g. date, flow/step data, etc.). This will only be visible if you have Include Header Row turned on.

Value

This is a pointer to the property name in the JSON - it will be mapped to the column name.