topic Re: How to replace a value from one table into another table in QlikView

How to replace a value from one table into another table

Fri, 11 Dec 2015 17:51:37 GMT

Been away from QlikView for a while and I forgot how to do this. Need to replace values, where the key exists, from one table into another table. For example, if I inline load two table:

BaseTable:

LOAD * INLINE [

KEY, FRUIT

1001, Apple

1002, Pear

1003, Grape

1004, Banana

];

SubTable:

LOAD * INLINE [

KEY, FRUIT_NAME

1001, Honeycrisp

1004, Yellow Banana

];

How can I create a resulting table of:

1001, Honeycrisp

1002, Pear

1003, Grape

1004, Yellow Banana

Re: How to replace a value from one table into another table

maxgro — Fri, 11 Dec 2015 18:02:52 GMT

With a mapping table

SubTable:

Mapping

LOAD * INLINE [

KEY, FRUIT_NAME

1001, Honeycrisp

1004, Yellow Banana

];

BaseTable:

LOAD KEY,

ApplyMap('SubTable', KEY, FRUIT) as FRUIT

INLINE [

KEY, FRUIT

1001, Apple

1002, Pear

1003, Grape

1004, Banana

];

Re: How to replace a value from one table into another table

Clever_Anjos — Fri, 11 Dec 2015 18:33:09 GMT

One posible approach

SubTable:

mapping LOAD * INLINE [

KEY, FRUIT_NAME

1001, Honeycrisp

1004, Yellow Banana

];

BaseTable:

LOAD KEY,ApplyMap('SubTable',KEY,FRUIT) as FRUIT INLINE [

KEY, FRUIT

1001, Apple

1002, Pear

1003, Grape

1004, Banana

];

Re: How to replace a value from one table into another table

Clever_Anjos — Fri, 11 Dec 2015 18:33:54 GMT

Ops, haven´t seen that maxgro already answered