topic Re: renaming a particular value in the table at script load in QlikView

renaming a particular value in the table at script load

sayadutt — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: renaming a particular value in the table at script load

Vegar — Wed, 28 Aug 2019 22:18:33 GMT

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

Re: renaming a particular value in the table at script load

Arthur_Fong — Wed, 28 Aug 2019 23:53:46 GMT

Refer attached qvw if you are lost in the script:

Thanks and regards,

Arthur Fong

Re: renaming a particular value in the table at script load

sayadutt — Thu, 29 Aug 2019 03:35:47 GMT

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

Re: renaming a particular value in the table at script load

Arthur_Fong — Thu, 29 Aug 2019 03:43:39 GMT

Attached is the reuploaded qvw.

Thanks and regards,

Arthur Fong

Re: renaming a particular value in the table at script load

Brett_Bleess — Thu, 05 Sep 2019 21:03:12 GMT

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