How to replace the value of table.

[#1]

Hi community,

I have to replace value from one table  to another table .

Please refere below sample data -

Base data :

ID         BS        PS

1          A          B

2          C          D

3          A          B

4          A          A

5          E          H

Sub Table

ID      BS        PS

1       C           C

3       D           D

So my expected answer is -

ID         BS        PS

1          C          C

2          C          D

3          D          D

4          A          A

5          E          H

Thanks in Advance

[#2]

Thank u Sunny,

Now i understand this.

[sunny_talwar]

Kush how are you checking your responses before you post? Are you just doing out of your best guess? That is amazing

[Kushal_Chawda]

Sunny, i just reply based on my experience not guess.. but yea without checking in Qv its like guess only.

[sunny_talwar]

That's what I meant, sorry if it sounded otherwise. But that amazing. Are you working on another technology now?

[Kushal_Chawda]

Avinash.. it's fine..  for moment u really made me think of the logic again.. bcuz it was from one of the Qv champ

[Kushal_Chawda]

Dont be sorry bro.. u r rite.. no i am still working on Qv but probably will move to microstrategy

[sunny_talwar]

Damn it!! Is Qlik going to loose one of the genius minds then . I hope you will continue to contribute here

[Kushal_Chawda]

Yeah i will surely contribute.. also there are many things still to learn..

[Anonymous]

Hi kushal,

your answer should working !!!

I got the ouput as needed by    ishwar10..

thanks to kushal ...

sorry for posting   although  question has been Answer  ....

//***********************************************************

map_bs:

mapping LOAD * INLINE

[

ID, BS

1, C

3, D

];

MAP_PS:

MAPPING LOAD * inline

[

ID, PS

1, C

3, D

];

basedata:

LOAD *,

  applymap('map_bs',ID,BS) AS BSMATCHED,

  APPLYMAP('MAP_PS',ID,PS) AS PSMATCHED

INLINE

[

  ID, BS, PS

  1, A, B

  2, C, D

  3, A, B

  4, A, A

  5, E, H

  ];

//*************************************************************

TABLE BOX

[sunny_talwar]

Way to go