CSV/Delimited Input

Steps

  1. Input
  2. Transformations
  3. Output
  4. Generated Code
  5. More Transformations

CSV/Delimited Input

Select the initial data format or leave as "Generic" to decide later.
File The CSV/delimited file to open.
Field Separator Leave blank for default (comma).
Line Separator Leave blank for default (all of \n, \r, and \r\n).
Quote Char Leave blank for default (double quote - ").
Allow Multi-line Allow quoted fields to contain line-breaks.
Trim Fields Remove leading and trailing whitespace.
Starting Row Number of lines to skip before reading.
Last Row All rows are read if less than zero.
Field Names in First Row The first line of records are the field names.
Field Names One field name per line. This is a hint to the wizard to tell it the fields available for later steps.
Mobile Analytics