Replace values in tables

[#1]

I load the parameters from an excel file - fdProductGroup, fdProduct, fdBrand.

From another system - called X - I load products - in the field fdProduct I have correlating values to excel file´s fdProduct field as well as fdBrand. I'm not happy with this because in my QV application they needs to be separated.

What I would like to do to get order in my QlikView life is to:

• replace the brand values (fdProduct) loaded from the system X with fdBrand from the excel file.

I do not want concatenate it all to a mess. I have attached example file.

Grateful for any suggestion.

Simplied, I load a table like this:

Product Brand

A 1

A 2

B 3

C 4

C 4

Then I have a mixed 'brands & products' table:

Product

A

B

C

3

4

My wished result would be:

Product

A

B

C

B

C