Title case mapping?

[JacobTews]

Hello, wonderful Qlik community!

I am interested in pushing some string manipulation from Sense upstream into Compose. Is there an easy way to map an all-uppercase field to a title case? Some strings have multiple words, some a single word, and at least one a hyphen.

For example:

HAMPTON

NEWPORT NEWS

RICHMOND-DOWNTOWN

should result in:

Hampton

Newport News

Richmond-Downtown

I suspect the most straightforward solution is a CASE statement, especially since the table in question has only ~20 location names, but I keep thinking there has to be something more elegant and extensible. A broader solution would be nice for name attributes, for example.

Any ideas?

Qlik Compose Qlik Compose for Data Warehouses 

[JacobTews]

As a follow-up, I currently have a UDF which does the transformation I wish to achieve. Compose seems to have access to it when testing the mapping:

and even can apply the UDF to the whole table in question (when clicking "Preview Results"):

However, Compose can't find it when validating:

I also tried to reference it as a Reusable Transformation, to no avail:

Is the issue the schema in which the UDF is stored? Or is it something else entirely?

For reference (in case someone knows how to easily translate this into a mapping in Compose), here's the UDF:

Looking forward to hearing what you brilliant folks have to say!

[JacobTews · Accepted solution]

Thanks to the quick help of @shashi_holla at Qlik support, here's the solution:

The UDF must be called by its full [database].[schema].[function_name] name in the expression to be used in the Mapping stage.

I hope this is helpful to y'all!