- Joined
- Mar 18, 2021
- Messages
- 2
Hi all,
Maybe it is a stupid question by I can't understand how to use distinct option for ConcatSet Function. Could you explain with a sample how to use this parameter? My case is elementary, I have (sample based on SW EO database) Circuit business collections (BC) and a set of Segments connected to the Circuit (1:n) And I am trying to get field with concatenated values of all Owner Name field from all segments without duplication.
It would be good to see more examples for functions with a detailed description in the documentation.
More complex question, how to meet such requirement: Same Circuit BC connected to the Pole BC (1:n). Poles BC have field "Number". I have Circuit with 10 poles which have such sequence of values in Number field (1,2,3,6,8,34,35,37,38,39), and we need to do special type of concatenation with such result - (1-3, 6-8, 34-39)
Maybe it is a stupid question by I can't understand how to use distinct option for ConcatSet Function. Could you explain with a sample how to use this parameter? My case is elementary, I have (sample based on SW EO database) Circuit business collections (BC) and a set of Segments connected to the Circuit (1:n) And I am trying to get field with concatenated values of all Owner Name field from all segments without duplication.
distinctValue | Comparable | Yes | "" | The value that determines the duplicate behavior; only one element of the candidates with this distinctValue will be considered. |
More complex question, how to meet such requirement: Same Circuit BC connected to the Pole BC (1:n). Poles BC have field "Number". I have Circuit with 10 poles which have such sequence of values in Number field (1,2,3,6,8,34,35,37,38,39), and we need to do special type of concatenation with such result - (1-3, 6-8, 34-39)