topic Re: Any way to replace one value with another value in entire data model irrespective of columns? in QlikView https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382874#M421300 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use</P><P>Mapping Load and ApplyMap</P><P>or</P><P>LOAD</P><P>...</P><P>If(Field='USA','America',Field) as Field</P><P>From Table;</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Thu, 24 Aug 2017 21:23:38 GMT antoniotiman 2017-08-24T21:23:38Z Any way to replace one value with another value in entire data model irrespective of columns? https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382872#M421298 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Is there a way to replace one value with another value in entire data model irrespective of columns?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">for example if I have one value as <STRONG>USA</STRONG> and I want to replace it with <STRONG>AMERICA</STRONG> in all columns ( Ex:100 columns) .</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Any ideas ?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks,</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Chiru<BR /></SPAN></P></BODY></HTML> Thu, 24 Aug 2017 21:19:59 GMT https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382872#M421298 chiru_thota 2017-08-24T21:19:59Z Re: Any way to replace one value with another value in entire data model irrespective of columns? https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382873#M421299 <HTML><HEAD></HEAD><BODY><P>Any specific reason or purpose of having 100 columns with same value? Just curious to know the requirement. Can you elaborate a little please ? You mean here 100 rows ?</P></BODY></HTML> Thu, 24 Aug 2017 21:22:14 GMT https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382873#M421299 vishsaggi 2017-08-24T21:22:14Z Re: Any way to replace one value with another value in entire data model irrespective of columns? https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382874#M421300 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use</P><P>Mapping Load and ApplyMap</P><P>or</P><P>LOAD</P><P>...</P><P>If(Field='USA','America',Field) as Field</P><P>From Table;</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Thu, 24 Aug 2017 21:23:38 GMT https://community.qlik.com/t5/QlikView/Any-way-to-replace-one-value-with-another-value-in-entire-data/m-p/1382874#M421300 antoniotiman 2017-08-24T21:23:38Z