Flat File

  • Published on Jan 6, 2023
  • 1 minute(s) read
Prev Next

Description

The Flat File Export Node node is used to export a data set to a flat file.


Configuration Options

Basic Configuration Options

Setting Description\Parameters
File Name Location of the file to export. This is the full path to the file, including the drive on which it lives. The path can either be entered manually here, or selected using the File Browser.
Delimiter Specifies the delimiter that should be used to parse the selected file.

Options
  • Comma
  • Tab
  • Pipe
First Row is Header Specifies if the first row in the file should be loaded as row header metadata. If this box is checked, the first row will be loaded as header metadata.
Decimal Places Specifies the number of decimal places to which any Double data type columns will be truncated.

Actions

Action Description
Browse Opens the File Browser Dialog. This dialog can be used to find an export file for the node to use.
Preview After configuring the node, the source data can be previewed by clicking the Preview button.

File Browser Dialog

The Browse button opens the File Browser dialog. This dialog can be used to find a source file for the node to use.

The Root Directoryis the full path to the location of the source file. After entering a path, push the refresh button to update the list of relevant files based on the File Type filter.

After clicking on a file, it will be added to the File Name input box. Click the Open button to return to the main dialog.