This Specification Task reads in a multiline text file, and passes the data into an existing Simple Table in DriveWorks.
If a line contains commas it will be separated into different columns in the table.
If a single entry starts and finishes with quotes, it will be taken as a single column entry even if it contains a comma.
|Title||Changes the Title (not the name) of the task.|
|File Name||File Name of the txt or csv file - Including Extension.|
|Simple Table Name||The name of the Simple Table that the array value will be written to.|
|First Line is Headers||TRUE if the first line in the text file is to be treated as headers, FALSE to use generic headers instead (Column1, Column2....ColumnN).|
|Constant Name||Constant that the none empty line count will be stored in for reference only.|
|Delimiter||Character that is used between the values on each row (comma by default).|