Qlik Community

Qlik Sense Cloud Discussions

Not applicable

Excel load text converted to number

Hello,

Am trying to load a spreadsheet into Qlik Cloud that will act as a dimension (see attaced).

I have a number of values in a column that is a text column but they are all look like numbers.....

000

0000

1000

100

2000

200

etc, etc

After the upload, 0000 is no longer in the table and it looks like it has merged this with 000.

It looks like its converted to a number....but how do I force the upload to treat this as a text so I have two separate values?

1 Reply
kenphamvn
Contributor III

Re: Excel load text converted to number

Hi

Try this

[Exported]:

LOAD text([O-Dept Code]) as [O-Dept Code],

[O-Dept Desc],

[R-Dept]

FROM [lib://Dolo/Oracle - Department.xlsx]

(ooxml, embedded labels, table is Exported);