topic Replace values in tables in QlikView https://community.qlik.com/t5/QlikView/Replace-values-in-tables/m-p/200702#M59138 <HTML><HEAD></HEAD><BODY><P>I load the parameters from an excel file - fdProductGroup, fdProduct, fdBrand.</P><P>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.</P><P>What I would like to do to get order in my QlikView life is to:</P><P></P><UL><LI>replace the brand values (fdProduct) loaded from the system X with fdBrand from the excel file.</LI></UL><P></P><P>I do not want concatenate it all to a mess. I have attached example file.</P><P>Grateful for any suggestion.</P><P>Simplied, I load a table like this:</P><P>Product Brand</P><P>A 1</P><P>A 2</P><P>B 3</P><P>C 4</P><P>C 4</P><P>Then I have a mixed 'brands &amp; products' table:</P><P>Product</P><P>A</P><P>B</P><P>C</P><P>3</P><P>4</P><P>My wished result would be:</P><P>Product</P><P>A</P><P>B</P><P>C</P><P>B</P><P>C</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 14 Sep 2010 19:50:56 GMT 2010-09-14T19:50:56Z Replace values in tables https://community.qlik.com/t5/QlikView/Replace-values-in-tables/m-p/200702#M59138 <HTML><HEAD></HEAD><BODY><P>I load the parameters from an excel file - fdProductGroup, fdProduct, fdBrand.</P><P>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.</P><P>What I would like to do to get order in my QlikView life is to:</P><P></P><UL><LI>replace the brand values (fdProduct) loaded from the system X with fdBrand from the excel file.</LI></UL><P></P><P>I do not want concatenate it all to a mess. I have attached example file.</P><P>Grateful for any suggestion.</P><P>Simplied, I load a table like this:</P><P>Product Brand</P><P>A 1</P><P>A 2</P><P>B 3</P><P>C 4</P><P>C 4</P><P>Then I have a mixed 'brands &amp; products' table:</P><P>Product</P><P>A</P><P>B</P><P>C</P><P>3</P><P>4</P><P>My wished result would be:</P><P>Product</P><P>A</P><P>B</P><P>C</P><P>B</P><P>C</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 14 Sep 2010 19:50:56 GMT https://community.qlik.com/t5/QlikView/Replace-values-in-tables/m-p/200702#M59138 2010-09-14T19:50:56Z