topic Translate SQL CAST to LOAD in QlikView https://community.qlik.com/t5/QlikView/Translate-SQL-CAST-to-LOAD/m-p/448688#M167452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've this problem.</P><P>In a SQL SELECT I have a field containing "2 D1", if I cast that to integer - CAST(myField as INT) - in a SQL SELECT it does work and converts my "2 D1" string in 20 (int).</P><P>How can I achieve that in a LOAD? Is that possible?</P><P></P><P>Thank you in advance,</P><P>Regards</P></BODY></HTML> Fri, 12 Apr 2013 10:22:43 GMT 2013-04-12T10:22:43Z Translate SQL CAST to LOAD https://community.qlik.com/t5/QlikView/Translate-SQL-CAST-to-LOAD/m-p/448688#M167452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've this problem.</P><P>In a SQL SELECT I have a field containing "2 D1", if I cast that to integer - CAST(myField as INT) - in a SQL SELECT it does work and converts my "2 D1" string in 20 (int).</P><P>How can I achieve that in a LOAD? Is that possible?</P><P></P><P>Thank you in advance,</P><P>Regards</P></BODY></HTML> Fri, 12 Apr 2013 10:22:43 GMT https://community.qlik.com/t5/QlikView/Translate-SQL-CAST-to-LOAD/m-p/448688#M167452 2013-04-12T10:22:43Z