Load value as integer?

[quriouss]

I have some values being loaded from an OLE DB connection to SAP BW.  They are integers (either 1 or NULL() ) but the ones are being imported as 1.00

How do I force the LOAD statement to treat them as integer values?  (I can multiply by 1 but that seems an inelegant solution).

[sunny_talwar]

May be this:

LOAD Num(Field, '##') as Field

or may be one of these

Round(Field) as Field

Ceil(Field) as Field

Floor(Field) as Field

[marcus_sommer]

Try it with: floor(Field)

- Marcus