Reference: Data Change Task Source Settings
Workday displays the
Source Settings
option in the Source
step of Create Data Change Task
when you select Azure Blob
and Google Cloud Storage
as the source type.The Source Settings help you define how to parse an uploaded file. You can click
Add Setting
in Source Settings
to override the source settings. Workday will persist the overridden values when running the data change task. When you click
Add Setting
, Workday will display 1 source setting for you to override the existing value. These are the different source settings available for you to override the values: Setting | Description |
|---|---|
First Row as Headers
| Select True to use the first row of your file as column names. If you select False , columns will be numbered. Example: Column 1 , Column 2 etc. |
Field Delimiter
| The character or hexadecimal value used to separate fields within a row. |
Row Delimiter
| The character or hexadecimal value used to separate rows. Leave this field empty to automatically detect any newline character. |
Skip Rows from Top
| The number of rows to ignore at the very beginning of the file. |
Skip Header Comments
| Select True to ignore lines starting with # at the top of the file. |
Quote Escape Character
| The character used to escape a quote character within a field value. |
Quote Character
| The character used to enclose field values, especially those containing delimiters. |
Trim Field Whitespace
| Controls how whitespace is handled for field values. |
Trim Whitespace from Quoted Values
| If the Trim Field Whitespace field has an option to trim any whitespace, select True to trim whitespace from values enclosed in quotes. |
Ignore Incomplete Rows
| Select an option to either include or ignore the rows that don’t have the expected number of fields. |