topic replace new content in QlikView

replace new content

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All, I have two tables :

I want to replace the product code with the new product code from 2nd table.

plz suggest.

sunny_talwar — Mon, 11 Sep 2017 13:00:59 GMT

Try this

MappingTable:

Mapping

LOAD * INLINE [

oldproductcode, new product code

58, AH67

100, LK22

37, CY13

44, OL09

33, PE55

];

Fact:

LOAD *,

ApplyMap('MappingTable', productcode, 'N/A') as New_Product_Code;

LOAD * INLINE [

product, productcode

bulb, 58

radio, 100

printer, 37

computer, 33

];

sunny_talwar — Mon, 11 Sep 2017 13:01:31 GMT

The idea is similar to the idea provided here:

its_anandrjs — Mon, 11 Sep 2017 13:03:53 GMT

Do you have this new field values in any table let me know.