topic Re: How to upload a text in QlikView https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399956#M700385 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This forces it to load as text:</P><P></P><P>LOAD Text(MyField) as MyField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 03 Dec 2012 11:52:04 GMT jonathandienst 2012-12-03T11:52:04Z How to upload a text https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399955#M700384 <HTML><HEAD></HEAD><BODY><P>Hi, i've this problem: inside my script, i need to upload a text from an excel where this text is '01'. Qlikview change automatically the field into a number. I've tried to change .xls into&nbsp; .csv&nbsp; but after upload this field became a number. How can i force text format? Tks</P></BODY></HTML> Mon, 03 Dec 2012 11:48:46 GMT https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399955#M700384 canmarroig 2012-12-03T11:48:46Z Re: How to upload a text https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399956#M700385 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This forces it to load as text:</P><P></P><P>LOAD Text(MyField) as MyField,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 03 Dec 2012 11:52:04 GMT https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399956#M700385 jonathandienst 2012-12-03T11:52:04Z Re: How to upload a text https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399957#M700386 <HTML><HEAD></HEAD><BODY><P>you must read this Diemnsion as text</P><P></P><P>text(Dimension) as Dimension</P></BODY></HTML> Mon, 03 Dec 2012 11:52:56 GMT https://community.qlik.com/t5/QlikView/How-to-upload-a-text/m-p/399957#M700386 MEllinghausen 2012-12-03T11:52:56Z