Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
L_VN
Partner - Contributor III
Partner - Contributor III

For each key in map

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. 

 

 

Labels (1)
0 Replies