Data converted to scientific notation

[cliff_clayman]

I have a field that is a text field in my SQL table.  I went to great lengths to ensure this field gets assigned as text in the database.  When I add it to my Qlikview report, some of the values are still showing as scientific notation.  I load many other fields into the report and I just do a SELECT * FROM TableName.  How can I LOAD the field as TEXT in the script and just call out the field(s) I want to make as text?

[sunny_talwar]

May be load like this:

LOAD Num(GLAcct) as GLAcct;

SELECT GLAcct FROM dbo.GRIR_Main;

[cliff_clayman]

How do I load all the rest of the fields without specifically listing them all out?

[swuehl]

Or do you want to keep it as text?

LOAD Text(GLAcct) as GLAcct;

SELECT GLAcct FROM dbo.GRIR_Main;

[sunny_talwar]

May be like this

LOAD *,

          Num(GLAcct) as GLAcct1;

SELECT GLAcct FROM dbo.GRIR_Main;

DROP Field GLAcct;

RENAME Field GLAcct1 as GLAcct;

[sunny_talwar]

Have not tried this, but you can give this a try

TempTable:

LOAD Num(0) as GLAcct

AutoGenerate 0;

SELECT GLAcct FROM dbo.GRIR_Main;

DROP Table TempTable;

[cliff_clayman]

I do want to keep it as text.  When I use Num(), I lose some of the data.  When I use Text(), I still see scientific notation.

[cliff_clayman]

That does not work as I do not get any fields to display.

[sunny_talwar]

No fields show up? Not even GLAcct

[sunny_talwar · Accepted solution]

My bad, try this

TempTable:

LOAD Num(0) as GLAcct

AutoGenerate 0;

SELECT * FROM dbo.GRIR_Main;

DROP Table TempTable;