New line for "CSV"/"Fixed-length"

For files that contain data in CSV or fixed-length format, the structure of the data is essentially determined by the data that forms one line.

Nodes have an attribute "Line break", which determines whether a new line should be started after the node has been processed. If this property has the value" Yes", the mapper works as follows.

• After processing the node, a new line is started.

• If the node contains output fields before a subnode with a line break, then the associated output fields and subnodes are placed in one line.

• If the node contains output fields after a subnode with a line break, the associated output fields are placed in a new line.

If attribute "Line break" has the value "No", there will be no new line created after a node is exited. The following screenshot shows the effects when the "Line break" attribute has value "No" for both a node and a subnode.

(1) Attribute "Line break" of node "node" has the value "No".

(2) Attribute "Line break" of node "Subnode" also has the value "No".

(3) With those settings, all fields will be written in one line.

The next screenshot shows the effects if the "Line break" attribute for document type "CSV"/"Fixed-length" has value "Yes" for a node and value "No" for a subnode.

(1) Attribute "Line break" of node "node" has the value "Yes". Therefore, a line feed is executed after exiting the node in the target tree.

(2) Attribute "Line break" of node "Subnode" also has the value "No".

(3) With those settings, all fields will be written in one line. A line feed is executed after exiting the node.

(4) The values of the subsequent node will be written in one line and a line feed will be executed after that.

The next screenshot shows the effects if the "Line break" attribute for document type "CSV"/"Fixed-length" has value "No" for a node and value "Yes" for a subnode.

(1) Attribute "Line break" of node "node" has the value "No".

(2) Attribute "Line break" of node "Subnode" has the value "Yes". Therefore, after exiting the node in the target tree, a line feed is executed.

(3) All values of the fields will be written in one line.

(4) All values of the fields (and also those of the subsequent node) will be written in one line.

(5) After exiting the node "Subnode" a line feed is executed.

(6) The value of the field will be written in one line.

The last screenshot shows the effects if the "Line break" attribute for document type "CSV"/"Fixed-length" has value "Yes" for a node and for a subnode.

(1) Attribute "Line break" of node "node" has the value "Yes". Therefore, after exiting the node in the target tree, a line feed is executed.

(2) Attribute "Line break" of node "Subnode" has the value "Yes". Therefore, after exiting the node in the target tree, a line feed is executed.

(3) The values of the fields will be written in one line. After exiting node "Subnode" a line feed is executed.

(4) The values of the fields will be written in one line. After exiting node "node" a line feed is executed.