Text() function in LOAD returns Scientific Notation

[#1]

I am loading a column using the Text() function.  The column contains integers.  But when I use the Text() function in the Load, the result is displayed as scientific notation (for example:  5.9489797e+008).

LOAD

     Text(FIELDNAME)  As [New Field Name]

RESIDENT  TableName;

If (after the Load), I create a straight table and evalute the same field using an identical Text() expression, it evalutes just fine (not e-notation).

Any ideas on why the Text() function in the LOAD evaluates to e-Notation?

[swuehl · Accepted solution]

Hi,

I am not really into the internals, just guessing that the internal representation as read from the data source differs from the standard representation after load (the standard which you can set in the beginning of your script as default representations).

Have you tried formatting the number first?

like

Text(num(FIELDNAME,'FORMATCODE')) as ...

Regards,

Stefan

[#3]

Thanks so much, Stefan.

I'm not sure why this was occurring (these are essentially int values loaded from a SQL Server table to a qvd, then loaded from that qvd and joined, etc. here), but formatting via NUM() inside the Text() function seemed to do the trick.