11-16-2020 03:31 AM
Can anybody help me out how to use ORDERBY in the CONCATENATE function?
A simple concatenate works fine
CONCATENATE('; ', Input.PARCEL)
and results in a list of parcelnumbers:
LDE02D 1521; LDE02D 1270; LDE02D 1520; LDE02D 1575; LDE02D 0466; LDE02D 1527; LDE02D 1525; BTL00P 0404; LDE02D 0522; LDE02D 1526; LDE02D 1522
Now I want them to be ordered alphabetically, my first thought was to use ORDERBY like this
CONCATENATE('; ', Input.PARCEL, Input.PARCEL)
But that seems to be invalid.......
Tried all kind of values without result.
Thanks in advance
Solved! Go to Solution.
11-16-2020 06:26 AM
Solved it with the help of some older articles in the community.
The ORDERBY should be a nummeric value, so had to replace the text (alphabet) by nummeric values through 26 nested Replace-functions
If someone knows a more efficient way............love to know.