topic Re: Prefix the Field Values - But not hard code - HOW? in QlikView https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908411#M315470 <HTML><HEAD></HEAD><BODY><P>Thanks very much Marcus. That helped!</P></BODY></HTML> Mon, 03 Aug 2015 15:54:30 GMT dmohanty 2015-08-03T15:54:30Z Prefix the Field Values - But not hard code - HOW? https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908409#M315468 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a Field, let say Column A, where I have a 1000 of values available. Now I need here to prefix all the values with a common name, lets say - 'TEST_'</P><P></P><P>Example</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="158"><TBODY><TR><TD height="20" width="94">Original Table</TD><TD width="64">New Table</TD></TR><TR><TD height="20">Column A</TD><TD>Column A</TD></TR><TR><TD height="20">abc</TD><TD>TEST_abc</TD></TR><TR><TD height="20">xyz</TD><TD>TEST_xyz</TD></TR><TR><TD height="20">cba</TD><TD>TEST_cba</TD></TR><TR><TD height="20">zyx</TD><TD>TEST_zyx</TD></TR></TBODY></TABLE><P></P><P></P><P>How can this be achieved?&nbsp; Please suggest!</P></BODY></HTML> Mon, 03 Aug 2015 15:34:50 GMT https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908409#M315468 dmohanty 2015-08-03T15:34:50Z Re: Prefix the Field Values - But not hard code - HOW? https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908410#M315469 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>New:</P><P>Load 'TEST_' &amp; [Column A] as [New Column A] Resident OriginalTable;</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 03 Aug 2015 15:41:02 GMT https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908410#M315469 marcus_sommer 2015-08-03T15:41:02Z Re: Prefix the Field Values - But not hard code - HOW? https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908411#M315470 <HTML><HEAD></HEAD><BODY><P>Thanks very much Marcus. That helped!</P></BODY></HTML> Mon, 03 Aug 2015 15:54:30 GMT https://community.qlik.com/t5/QlikView/Prefix-the-Field-Values-But-not-hard-code-HOW/m-p/908411#M315470 dmohanty 2015-08-03T15:54:30Z