Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdanqua
Contributor III
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.

 

Labels (2)
2 Replies
rwunderlich
Luminary Alumni
Luminary Alumni

Use the MapSubstring() function.

-Rob

ericdanqua
Contributor III
Contributor III
Author

Thanks A lot Rob, worked like a charm.