For each key in map

L_VN — Fri, 25 Aug 2023 10:55:59 GMT

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.

topic For each key in map in App Development