topic Re: How to convert customers id in load script in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537461#M690340 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA...&nbsp;&nbsp; Hope it will help you</P></BODY></HTML> Thu, 10 Oct 2013 07:40:45 GMT 2013-10-10T07:40:45Z How to convert customers id in load script https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537457#M690336 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with:</P><P></P><P>ID</P><P>1</P><P>20</P><P>333</P><P>400</P><P></P><P>In the script process i'd like to convert in this format C######</P><P></P><P>C000001</P><P>C000020</P><P>C000333</P><P>C000400</P><P></P><P>thank's guys</P><P></P><P>Eduard</P></BODY></HTML> Thu, 10 Oct 2013 07:12:56 GMT https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537457#M690336 ecabanas 2013-10-10T07:12:56Z Re: How to convert customers id in load script https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537458#M690337 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> you could concat 'C'&amp;right('000000'&amp;ID,6)</P></BODY></HTML> Thu, 10 Oct 2013 07:16:42 GMT https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537458#M690337 bbi_mba_76 2013-10-10T07:16:42Z Re: How to convert customers id in load script https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537459#M690338 <HTML><HEAD></HEAD><BODY><P>You can concat that<BR />While Loading</P><P>Load 'C' &amp; right('000000'&amp;ID,6)</P></BODY></HTML> Thu, 10 Oct 2013 07:22:03 GMT https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537459#M690338 saumyashah90 2013-10-10T07:22:03Z Re: How to convert customers id in load script https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537460#M690339 <HTML><HEAD></HEAD><BODY><P>For example like this:</P><P></P><P>load num(ID, 'C000000') as ID Inline [</P><P>ID</P><P>1</P><P>20</P><P>333</P><P>400];</P></BODY></HTML> Thu, 10 Oct 2013 07:25:20 GMT https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537460#M690339 Gysbert_Wassenaar 2013-10-10T07:25:20Z Re: How to convert customers id in load script https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537461#M690340 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA...&nbsp;&nbsp; Hope it will help you</P></BODY></HTML> Thu, 10 Oct 2013 07:40:45 GMT https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537461#M690340 2013-10-10T07:40:45Z Re: How to convert customers id in load script https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537462#M690341 <HTML><HEAD></HEAD><BODY><P>Thank's Saumya <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Thu, 10 Oct 2013 08:55:22 GMT https://community.qlik.com/t5/QlikView/How-to-convert-customers-id-in-load-script/m-p/537462#M690341 ecabanas 2013-10-10T08:55:22Z