Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

canmarroig
New Contributor III

How to upload a text

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: How to upload a text

Hi

This forces it to load as text:

LOAD Text(MyField) as MyField,

     ...

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: How to upload a text

Hi

This forces it to load as text:

LOAD Text(MyField) as MyField,

     ...

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
mallemalle
Contributor III

Re: How to upload a text

you must read this Diemnsion as text

text(Dimension) as Dimension

Community Browser