I have a table with different links and a map like:
```
LinkTable:
load *
inline
[Link
Link1.qvd
Link2.qvd
Link3.xlsx
Link4.txt
];
mapChange:
mapping
Load* inline
[
Old, New
Old1, New1
Old2, New2
];
```
I want to create table where I apply the changes in the map to the links in the LinkTable if they match sort of like:
```
Replaced:
LOAD
if(WildMatch(Link, KEY), Replace(Link, KEY, applymap('mapChange', KEY), Link) as NewLinkTable,
Resident LinkTable;
```
The issue is that I want to wrap it in a for loop that tries the WildMatch for all keys in mapChange, and breaks after it's found a match.