topic Replace multiple strings with multiple strings in QlikView

Replace multiple strings with multiple strings

ericdelaqua — Sat, 16 Nov 2024 04:24:53 GMT

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.

Re: Replace multiple strings with multiple strings

rwunderlich — Tue, 19 Feb 2019 00:47:57 GMT

Use the MapSubstring() function.

-Rob

Re: Replace multiple strings with multiple strings

ericdelaqua — Tue, 19 Feb 2019 01:09:22 GMT

Thanks A lot Rob, worked like a charm.