Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
cliff_clayman
Contributor

Data converted to scientific notation

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?

1 Solution

Accepted Solutions

Re: Data converted to scientific notation

My bad, try this

TempTable:

LOAD Num(0) as GLAcct

AutoGenerate 0;

SELECT * FROM dbo.GRIR_Main;


DROP Table TempTable;

12 Replies

Re: Data converted to scientific notation

May be load like this:

LOAD Num(GLAcct) as GLAcct;

SELECT GLAcct FROM dbo.GRIR_Main;

cliff_clayman
Contributor

Re: Data converted to scientific notation

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

MVP
MVP

Re: Data converted to scientific notation

Or do you want to keep it as text?

LOAD Text(GLAcct) as GLAcct;

SELECT GLAcct FROM dbo.GRIR_Main;

Re: Data converted to scientific notation

May be like this

LOAD *,

          Num(GLAcct) as GLAcct1;

SELECT GLAcct FROM dbo.GRIR_Main;


DROP Field GLAcct;

RENAME Field GLAcct1 as GLAcct;

Re: Data converted to scientific notation

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
Contributor

Re: Data converted to scientific notation

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
Contributor

Re: Data converted to scientific notation

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

Re: Data converted to scientific notation

No fields show up? Not even GLAcct

Re: Data converted to scientific notation

My bad, try this

TempTable:

LOAD Num(0) as GLAcct

AutoGenerate 0;

SELECT * FROM dbo.GRIR_Main;


DROP Table TempTable;

Community Browser