asUniqueList

String functions AsUniqueList

syntax

• AsUniqueList(string_dataitem, separator)
• AsUniqueList(string_dataitem, separator, relation)

definition

• AsUniqueList(string_dataitem, separator) results in a string parameter with all unique values of string_dataitem, separated by the separator argument.
• AsUniqueList(string_dataitem, separator, relation) results in a string attribute with all unique values of string_dataitem, separated by the separator argument, grouped by the relation argument. The domain unit of the resulting attribute is the values unit of the relation.

applies to

• data items string_dataitem and separator with string value type
• relation with value type of the group CanBeDomainUnit

conditions

The domain units of arguments string_dataitem and relation must match.

example

1. parameter<string> CityListParam := AsUniqueList(City/Name, ';');  
result = 'Groningen;Delfzijl;Winschoten;Leeuwarden;Dokkum;Bolsward;Emmen;Assen;Hoogeveen'

2. attribute<string> CityList (Region) := AsUniqueList(City/Name, ';', City/Region_rel);

City/Name	City/Region_rel
'Groningen'	0
'Delfzijl'	0
'Delfzijl'	0
'Winschoten'	0
'Leeuwarden'	1
'Dokkum'	1
'Bolsward'	1
'Bolsward'	1
'Emmen'	2
'Assen'	2
'Hoogeveen'	2

domain City, nr of rows = 11

CityList
'Groningen;Delfzijl;Winschoten'
'Leeuwarden;Dokkum;Bolsward'
'Emmen;Assen;Hoogeveen'

domain Region, nr of rows = 3

see also

• AsExprList
• AsItemList
• AsDataString