Additional Settings

Configure the data parsing parameters and additional settings.

File Data Parsing Parameters

  1. Enter the character that you want to use as a delimiter in the Delimiter field. The default value is a comma (,). The source only supports single character delimiters. To use a tab as a delimiter, provide its Unicode value: \u0009.

  2. Enter a comment character in the Comment Character field. Records starting with the comment character are skipped by the source. The default value is #.

Additional Settings

  1. Enter the Number of Lines to Skip in the data file before parsing the data. For example, when the value is set to 1, the connector skips the 1st line of data from the input file along with the header line.

    Note
    The first line of the input file consists of column headers so the connector always skips the header section during aggregation.

  2. Enter the string which represents a filter object in the Filter String field.

    Any object matching this filter will be taken out of the dataset and will not be returned. For example, a filter that filters out all objects from the Marketing department is written as follows:

    department=="Marketing"

  3. Select Save.