Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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