CSV File Input

Delimiter

Delimiter in a CSV file for separating data lines.

string

Yes

,

Line Delimiter

Line delimiter, which can be any string specified by users based on the actual situation. The OS line delimiter is used by default.

string

No

\n

Filename as field

User-defined field whose value is the name of the file that stores the current data.

string

No

None

Absolute path

Indicates whether the file name used as the value of Filename as field contains an absolute path. Selecting the option button indicates that the file name contains an absolute path; deselecting the option button indicates that the file name does not contain a path.

boolean

No

Deselect

Validate input field

Checks whether the input field matches the value type. If the value is NO, no check is performed. If the value is YES, whether the input field matches the value type is checked. If the input fields do not match the value type, the line is skipped.

enum

Yes

YES

Input fields

Information about input fields:

• position: Position of the field after data lines in the source file are separated by delimiters. The position sequence starts from 1.
• field name: Field name.
• type: Field type.
• date format: If the field type is DATE, TIME, or TIMESTAMP, you must specify a time format. If the field type is set to other values, the time format is invalid. An example time format is yyyyMMdd HH:mm:ss.
• length: Field value length. If the actual field value is excessively long, the value is cut based on the configured length. When type is set to CHAR, spaces are added to the field value for supplement if the actual field value length is less than the configured length. When type is set to VARCHAR, no space is added to the field value for supplement if the actual field value length is less than the configured length.

map

Yes

None