CSVWithHeaderUnit

Group

Integration Units

Class Name

com.ebd.hub.datawizard.iu.CSVWithHeaderUnit

Function

The Integration Unit creates a CSV file with a header line consisting of the field names of the first active destination structure node.

Description


Introduction: Integration Units.


The Integration Unit creates a CSV file with a header line consisting of the field names of the first active destination structure node. In addition, the node attribute Only for SQL must be set to No.

The next line (or lines if you are working with a path) then consists of the field values.

Calculation fields are ignored. Subnodes are dissolved, i.e. their fields are used as if they were fields of the parent node.

See example profile below.

Parameter Description


Parameter Name

Allowed Values

Default Value

Description

always quote

true, false

false

Quoting all fields, even numeric values and values without special characters, or whitespaces.

as csv of excel

true, false

false

Create CSV file in Microsoft Excel conform format.

csv delimiter


;

CSV field delimiter (see note).

csv quote


"

Quote character.

end of line


\n

CSV line delimiter.

use normalized header names

true, false


If true, then a header field name field#3 becomes field.

Note: Particularly for the work with the data format CSV, a delimiter must be defined, which is expected at various points. If a non-printable character is to be used as the separator, e.g. a control character, that character can not simply be entered using the keyboard. In this case, a periphrasis is expected. The following periphrases are supported.


TAB

Horizontal tab.

NL

New line.

CR

Carriage return.

0x<hexcode>

Specified in hex code (2 characters [0-F]).


Note: Also see section Representation of Nonprintable Delimiters.