renaming a particular value in the table at script load

[sayadutt]

Hi All,

I have 2 tables which looks like below

Date	Team	Value
12-Aug	12	10
12-Aug	BB	20
12-Aug	CC	30

Date	Team	Value
13-Aug	AA	40
13-Aug	BB	50
13-Aug	CC	60

At script load, I want to join Team 12 with AA, as they are same.

Date	Team	Value
12-Aug	AA	10
12-Aug	BB	20
12-Aug	CC	30
13-Aug	AA	40
13-Aug	BB	50
13-Aug	CC	60

How I can do this?

[Vegar]

IF you have more  than one substitution you could look at the applymap() function, if there is only one substitution then you could just use the replace () function.

Good luck

[Arthur_Fong]

Refer attached qvw if you are lost in the script:

Thanks and regards,

Arthur Fong

[sayadutt]

I guess you have uploaded a wrong sample file. Can you please check.

[Arthur_Fong]

Attached is the reuploaded qvw.

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Sayantan, did Arthur or Vegar's post get you what you needed?  If so, be sure to use the Accept as Solution button on the post(s) that helped, so they get credit and others will know what actually helped you.

Here is a Design Blog on Apply Map just in case you need more details on that:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Regards,
Brett