Replace values in field

[CanOls]

Hi Qlik Community

I would like to compare data across two different tables. Both tables have a field that contain comparable data. They have a field in common that I use as a key to connect the two tables.

The problem is that the naming convention in the two tables is not quite the same. The field contains five possible values but two of the values are named differently. Is it possible to change the name of the values in the one table so that they match up in my Qlik App? 

Any help is appreciated

Casper

[QlikJunkie]

MapSubstring....!

see if it helps

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Mappi...

[CanOls · Accepted solution]

A co worker helped me out This solution did the trick.

     if ('FieldName'='FieldValue', 'NewValue, if( 'FieldName'='OtherFieldValue','OtherNewValue', FieldName)) as FieldName

This worked in the script.