Delimited File

  • delimiter: the delimiter character, use U+#### syntax (e.g. U+0001) for unicode characters

  • textQualifier: the text qualifier character, e.g. " (which would be represented as "")

  • headerRowsToIgnore: the number of records from the top of the file to ignore before the data starts (includes column header)

  • path: the path to the source file to load, this can reference an execution parameter (e.g. @file_path)

  • encoding: the encoding of the file, defaults to UTF8 if not specified, but also supports UTF8_BOM, ASCII, and UTF16

<DelimitedDataSource
delimiter=","
textQualifier="&quot;"
headerRowsToIgnore="0"
path="C:\Users\Cinchy\Sample.csv" encoding="UTF8">
<Schema>
<Column name="firstname" ordinal="1" dataType="Text" maxLength="50"
isMandatory="false" validateData="false" trimWhitespace="true" description=""/>
<Column name="lastname" ordinal="2" dataType="Text" maxLength="50"
isMandatory="false" validateData="false" trimWhitespace="true" description=""/>
<CalculatedColumn name="lob" formula="@lob" dataType="Text" maxLength="100"
isMandatory="false" validateData="false" description="" />
<CalculatedColumn name="name" formula="CONCAT(firstname, lastname)"
dataType="Text" maxLength="100" isMandatory="false" validateData="false"
description="" />
<Column name="net worth" ordinal="3" dataType="Number" maxLength="50"
isMandatory="false" validateData="true" trimWhitespace="true" description="">
<Transformations>
<StringReplacement pattern="\$" replacement="" />
</Transformations>
</Column>
</Schema>
<Filter/>
</DelimitedDataSource>