Replace values in script

[Hoowling]

Hi, 

I'm loading a ton of data into a qlikview application where I want to replace some of the input loaded with new values.
In below example I have the raw data stored in Table A, where the bold rows contain wrong "Type" values. I want to replace those values with the information in table B, column "Type". The end result should be as in Table C. 

Any suggestions on how to accomplish this? 

Table A				Table B				Table C
Voucher	Type	Value		Voucher	Type	Value		Voucher	Type	Value
100000	A	150		100001	A	200		100000	A	150
100001	B	200		100004	C	285		100001	A	200
100002	A	120		100008	B	433		100002	A	120
100003	C	300		100009	A	470		100003	C	300
100004	B	285						100004	C	285
100005	B	322						100005	B	322
100006	A	359						100006	A	359
100007	B	396						100007	B	396
100008	A	433						100008	B	433
100009	C	470						100009	A	470

[MayilVahanan · Accepted solution]

Hi

Hope voucher has unique values. In that case, try like below

MapType:

Mapping Load Voucher, Type from TableB;

Load Voucher, ApplyMap('MapType', Voucher, Type) as Type, Value from TableA;

[Hoowling]

Worked like a charm, thank you!