topic Re: Replacing field values in the data manager in QlikView https://community.qlik.com/t5/QlikView/Replacing-field-values-in-the-data-manager/m-p/16735#M789614 <HTML><HEAD></HEAD><BODY><P>Hello Pascal,</P><P></P><P>I would use a mapping loads to do this.</P><P></P><P>Please find the attached, hope it meets you requirement.</P><P></P><P>Thanks</P><P>Vamsee</P><P></P><P>Note:&nbsp;&nbsp;&nbsp; Instead of the inline table you can use an excel if the data set is huge</P></BODY></HTML> Tue, 13 Feb 2018 19:47:52 GMT vamsee 2018-02-13T19:47:52Z Replacing field values in the data manager https://community.qlik.com/t5/QlikView/Replacing-field-values-in-the-data-manager/m-p/16734#M789613 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to replace field values of dimensions in the data manager. For example I have the following field values: USA, US and United States, while i want them all to be named USA. This should be possible in the replace tab. However this is only possible when a table has 100 or less distinct values, while my table has 2800 distinct values. </P><P></P><P>Is there a way to solve this?</P><P></P><P>Regards,</P><P></P><P>Pascal</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Replacing-field-values-in-the-data-manager/m-p/16734#M789613 pascaldijkshoor 2020-11-25T16:16:04Z Re: Replacing field values in the data manager https://community.qlik.com/t5/QlikView/Replacing-field-values-in-the-data-manager/m-p/16735#M789614 <HTML><HEAD></HEAD><BODY><P>Hello Pascal,</P><P></P><P>I would use a mapping loads to do this.</P><P></P><P>Please find the attached, hope it meets you requirement.</P><P></P><P>Thanks</P><P>Vamsee</P><P></P><P>Note:&nbsp;&nbsp;&nbsp; Instead of the inline table you can use an excel if the data set is huge</P></BODY></HTML> Tue, 13 Feb 2018 19:47:52 GMT https://community.qlik.com/t5/QlikView/Replacing-field-values-in-the-data-manager/m-p/16735#M789614 vamsee 2018-02-13T19:47:52Z