Contents x
    Flat File
    • 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Flat File

    • Updated on 23 Dec 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Description

    Legacy-FlatFileSource1

    The Flat File source node is used to import data from flat files.

    Configuration Options

    Basic Configuration Options

    SettingDescription\Parameters
    File NameLocation of the file to import. 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.
    DelimiterSpecifies the delimiter that should be used to parse the selected file.

    Options
    • Comma
    • Tab
    • Pipe
    Quote CharacterSpecifies the character used to wrap column data between each delimiter.

    Options
    • AUTO - data fields wrapped with default (double quote)
    • NONE - data fields not wrapped
    • SINGLE - data fields wrapped with single quotes
    • DOUBLE - data fields wrapped with double quotes
    First Row is HeaderSpecifies 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.
    Use Data Type TemplateWhen selected this option will load the files data types from a user defined .jdt file. The .jdt file must use the same name as the File Name setting except the .jdt extension.
    Column Data TypeThis setting can be overridden and if the table is not populated click the Infer Data Types option.

    Node Features

    Infer Data Types

    Clicking the Infer Data Types button this will automatically infer the data types used for each column. These values can be overridden.

    Column Data Type - This setting can be overridden and if the table is not populated click the Infer Data Types option.

    File Browser

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

    After clicking on a file, it will be added to the File Name input.

    Misc. Node Requirements

    • This node supports comma, pipe, and tab delimited files only.
    • Data must be properly formatted to conform to standard delimited file conventions. For example each row should be terminated by a new line (\r\n).
    • Rows should not contain \r or \n characters outside of the newline.
    Was this article helpful?
    What's Next