How to upload a text

[canmarroig]

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  .csv  but after upload this field became a number. How can i force text format? Tks

[jonathandienst · Accepted solution]

Hi

This forces it to load as text:

LOAD Text(MyField) as MyField,

     ...

Regards

Jonathan

[MEllinghausen]

you must read this Diemnsion as text

text(Dimension) as Dimension