GeoMedia Discussions

Search for an answer, post a question, or answer other users' questions in our GeoMedia support discussions. This discussion board is a great way to collaborate with industry peers around the world. It is intended for discussion and support of the GeoMedia Desktop and Add-on applications.
Showing results for 
Search instead for 
Do you mean 
Reply
Occasional Contributor
Posts: 7
Registered: ‎04-02-2018
Accepted Solution

How to use ORDERBY in the CONCATENATE Functional Attribute ?

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

 

Jan

Occasional Contributor
Posts: 7
Registered: ‎04-02-2018

Re: How to use ORDERBY in the CONCATENATE Functional Attribute ?

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.

 

Regards

Jan