Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with different links and a map like:
```
LinkTable:load *inline[LinkLink1.qvdLink2.qvdLink3.xlsxLink4.txt];
mapChange:mappingLoad* inline[Old, NewOld1, New1Old2, 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:LOADif(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.