Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ericdanqua
New Contributor III

Replace multiple strings with multiple strings

Hello,

is it possible to replace multiple strings with multiple strings in the script.

I have this strings:

value,Newvalue

ADC,ABCD

AC,ABC

BC,ABC

And I have the following data :

table:

Load* Inline [Key,Value

key1 , 129BC32 ADC456AC

];

How can I replace the string in the values field on the table with the value of the map above? This is a big data exercise and a simple solution will be appreciated.

 

Tags (2)
Labels (2)
2 Replies
MVP & Luminary
MVP & Luminary

Re: Replace multiple strings with multiple strings

Use the MapSubstring() function.

-Rob

ericdanqua
New Contributor III

Re: Replace multiple strings with multiple strings

Thanks A lot Rob, worked like a charm.