NOTE: Some options in the following table collapse or are displayed only when selecting other options, such as a checkbox or selects.
Field | Required | Default | Multiple | Notes | Example |
---|---|---|---|---|---|
description | Yes | - | No | Name of the component application. | "tabular-files-extractor" |
properties | Yes | - | No | Configuration object | |
separatorAlt | Yes | comma (,) | No | The character that is used to separate each column on the tabular file. It can be: comma, semicolon, tab, pipe, SOH start of header (x001), dotaccent (·) (x307), c-cedilla (Ç), medium shade (▒), tilde (~) or a custom string separator (not longer than 5 characters) | comma (,) |
separator | Yes | "" | No | Custom separator string, cannot be longer than 5 characters | "^|" |
headersOnFirstRow | Yes | true | No | Whether to use the first row data as column names or not. If false, columns will be named column1, column2, ..., | true |
ignoreQuotes | Yes | true | No | Determine if the quotes are going to be used as literal text or not | true |
maxSubJobs | Yes | 0 | No | Max number of sub-jobs, 0 means process all sub-jobs | 0 |
maxLinesToRead | Yes | 0 | No | Max number of lines to read, 0 means process all lines | 0 |
genericColumnName | Yes | column | No | If column names are not specified in the first row, this prefix will be used for column names followed by a sequential number | "column" |
includeEmptyColumns | Yes | false | No | Whether or not to include empty columns in sub-jobs | false |
metadataMap | Yes | - | No | Configuration object for your mapping configuration | |
debug | No | false | No | Option if you want to debug messages enabled. | false |
NOTE: The following structure is not ordered by the sections of the component configuration.
Code Block | ||||
---|---|---|---|---|
| ||||
{ "type": "application", "appName": "Tabular Files Extractor", "appType": "tabular-files-extractor", "config": "com.accenture.aspire:app-tabular-files-extractor", "description": "tabular-files-extractor", "properties": { "debug": true, "separatorAlt": "comma", "separator": "comma", "headersOnFirstRow": true, "ignoreQuotes": true, "maxSubJobs": 0, "maxLinesToRead": 0, "genericColumnName": "column", "includeEmptyColumns": false, "metadataMap": { "map": [ { "@from": "field1", "@to": "myField1" }, { "@from": "field2", "@to": "myField2" } ] } } } |