DataFlux Data Management Studio 2.6: User Guide

Concatenation Node

Concatenate substrings together into a single string.

• In the case definitions, the chopped and processed substrings are reassembled in the same order and with the same inter-word (between words) whitespace as before chopping.
• In the standardization definitions, the outputs of each token group are concatenated. The separating characters between each token are specified in the node.

Used in:

• Case Definitions
• Standardization Definitions

Properties

Case Definitions

None

Standardization Definitions

A table with three columns:

• Use separator: click to include the separator string specified in the third column
• Token: the name of the token to which the separator can be applied
• Separator string: specifies the characters in the separator string, which appears before the token's output string if the first column selected

Click the up and down arrows to change the order of the tokens in the concatenated string.

Select a row and click the Edit icon to change the separator string for that token.

Output

Message

The message, "Changes were applied" always appears, since concatenation always happens.

Result

The string after concatenation.