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