Apply Map for Multiples Fields

[vikasmahajan]

Dear All

I have following data  Table A

                              Code Sales

                               1001  5000

                                2033  6000

                                3000  7000

                                1002  8000

and                              Table B

                                 Code , Add1,Add2,Add3

                                 1001 , PPP,QQQ,RRR

                                  2033 , XXX,YYY,ZZZ

                                  3000  , JJJ,KKK,LLL

I want to use apply map between this tables , as per qlikview takes only one parameter with apply map , is there any way take directly 3 fields of table B into Table A with joins if any approach in apply map directly.

Thanks in Adv

Vikas

[vikasmahajan]

No...

[vikasmahajan]

Thanks

I want to use apply map not join.

Vikas

[rubenmarin]

Hi Vikas, check the response of petter-s above, it's in one shot using ApplyMap()

[vikasmahajan]

Thanks I will check and get back you soon..

Vikas