Avoiding textfields to be read as numbers

[#1]

I read from a view in Oracle database where a field has different VARCHAR values '4140' and '04140' however in QLIKVIEW both becomes '04140'. Is there a way to tell Qlikview it is two distinct values without change the values?

There are other values with just text, and they are OK.

If I add an 'a' in front of the values in the Oracle view, no leading zeros are added in Qlikview. So I take it has to do with Qlikviews in memory representation. But the field is a VARCHAR so adding a to_char() doesn't help.

Is there an option, setting or another way that could prevent this?

[maxgro · Accepted solution]

in my oracle it seems it works with text

load DEPTNO, text(DNAME), LOC;

sql select * from dept;

oracle

qlikview

[#3]

Thanks.

That does it.

My problem was that I only had

LOAD

Select * FROM ...;

The trick about LOAD <mention all fields with formatting>;

                         SELECT * FROM ...;

keeps the data right, however the load is no longer generic.