topic Re: Create a Customerid from a code in QlikView https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934814#M322839 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>'C' &amp; NUM(yourfield,'000000') as&nbsp; yournewfield</P><P></P><P>from yourqvd.qvd(qvd)</P></BODY></HTML> Wed, 04 Nov 2015 10:50:44 GMT Clever_Anjos 2015-11-04T10:50:44Z Create a Customerid from a code https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934813#M322838 <HTML><HEAD></HEAD><BODY><P>Hi I have the following customerid:</P><P></P><P>1</P><P>2</P><P>3</P><P>12</P><P>100</P><P></P><P>and I would like to transform in "C000000" patern</P><P></P><P>C000001</P><P><SPAN style="font-size: 13.3333px;">C000002</SPAN></P><P><SPAN style="font-size: 13.3333px;">C000003</SPAN></P><P><SPAN style="font-size: 13.3333px;">C000012</SPAN></P><P><SPAN style="font-size: 13.3333px;">C000100</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I think it's easy but I am in a loop and blocked</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Many thank's</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Eduard<BR /></SPAN></P></BODY></HTML> Wed, 04 Nov 2015 10:45:46 GMT https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934813#M322838 ecabanas 2015-11-04T10:45:46Z Re: Create a Customerid from a code https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934814#M322839 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>'C' &amp; NUM(yourfield,'000000') as&nbsp; yournewfield</P><P></P><P>from yourqvd.qvd(qvd)</P></BODY></HTML> Wed, 04 Nov 2015 10:50:44 GMT https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934814#M322839 Clever_Anjos 2015-11-04T10:50:44Z Re: Create a Customerid from a code https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934815#M322840 <HTML><HEAD></HEAD><BODY><P>Or even simpler</P><P>num(yourfield,'C000000')</P></BODY></HTML> Wed, 04 Nov 2015 10:52:09 GMT https://community.qlik.com/t5/QlikView/Create-a-Customerid-from-a-code/m-p/934815#M322840 Clever_Anjos 2015-11-04T10:52:09Z