Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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;
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;
Worked like a charm, thank you!