Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdelaqua
Creator
Creator

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
Partner Ambassador/MVP
Partner Ambassador/MVP

Use the MapSubstring() function.

-Rob

ericdelaqua
Creator
Creator
Author

Thanks A lot Rob, worked like a charm.