Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

Use the MapSubstring() function.

-Rob

ericdanqua
Contributor III
Contributor III
Author

Thanks A lot Rob, worked like a charm.