Output Selector: Delimited List

1.3.3.10.2 Output Selector: Delimited List

The Delimited List output selector outputs all input values, or all distinct input values, in a delimited list.

Use the Delimited List output selector when you are merging records but want to retain multiple values for certain fields. For example, email addresses and phone numbers may be used to help identify duplicate individuals, but you may want to retain all distinct email addresses and phone numbers for those individuals in merged output.

The following table describes the configuration options:

Configuration Description

Configuration	Description
Inputs	Any String attributes from any input data sets.
Options	Specify the following options: `Distinct values only?`: drives whether to output all values, or whether only to output distinct values. Type: Yes/No. Default value: Yes. `Delimiter`: the delimiter used to separate values in output. Type: Free text. Default value: , `Ignore empty values?`: drives whether or not to output two delimiters in a row if there is an empty input value. Type: Yes/No. Default value: No. If No, two delimiters in a row will be output in order to show how many input values there were.If Yes, empty values will be ignored.

Inputs

Any String attributes from any input data sets.

Options

Specify the following options:

Distinct values only?: drives whether to output all values, or whether only to output distinct values. Type: Yes/No. Default value: Yes.
Delimiter: the delimiter used to separate values in output. Type: Free text. Default value: ,
Ignore empty values?: drives whether or not to output two delimiters in a row if there is an empty input value. Type: Yes/No. Default value: No.

If No, two delimiters in a row will be output in order to show how many input values there were.If Yes, empty values will be ignored.

Example

In this example, the Delimited List output selector is used to output all product codes from multiple records all representing the same individual

Example configuration

Distinct values only? = Yes

Delimiter = |

Ignore empty values? = Yes

Example output

The following table shows example output using the Delimited List selector:

Table 1-101 Example Output Using Delimited List Selector

Record A	Record B	Record C	Output value(Delimited List)
FIX2YR0550	FIX2YR0550	OFF2YR0550	FIX2YR0550\|OFF2YR0550
CAP2YR19XX	FIX5YR0550	OFF2YR-ASR00	CAP2YR19XX\|FIX5YR0550\|OFF2YR-ASR00
null	null	FIX3YR0780	FIX3YR0780
null	null	null	null
CAP2YR	FIX3YR7654		CAP2YR\|FIX3YR7654