Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Refer attached qvw if you are lost in the script:
Thanks and regards,
Arthur Fong
I guess you have uploaded a wrong sample file. Can you please check.
Attached is the reuploaded qvw.
Thanks and regards,
Arthur Fong
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