Placeholder "*" or "%" in mapping statement

[MaSo1996]

Hello, I'd like to create a map, that "shortens" names in various columns and I'm wondering, if there is a sollution for that in Qlik Sense - I tried with "*" and "%", but without succes:

map1:
mapping load *
inline [
oldName, newName
"miasto%", "miasto"
"powiat%", "powiat"];

Could You provide some help with that?

[Mark_Little]

Hi,

This isn't something that io have come across myself. 

Closest is applying a map to renamed them,

https://community.qlik.com/t5/Design/Renaming-Fields-with-a-Mapping-Table/ba-p/2054843

Mark

[Or]

https://qlikviewcookbook.com/recipes/download-info/mapping-with-wildcards/

[marcus_sommer]

I assume that your question isn't related to a field-renaming (in general possible per mapping but not different ones into a single field) else to adjust field-values. In this case you couldn't use an applymap() but a mapsubstring() - here a hint how you may go for it:

Re: Search string inside loop taking huge time - Qlik Community - 2520631