How to remove decimals during load

[iamthefixer]

Hello, I am loading hundreds of .xlsm files and found that values that are formatted as General in Excel are imported with 6 decimals into QV.

For example

Excel	QV
61040	61040.000000

What is the solution to get the following result in QV?

Expected result

Excel	QV
61040	61040

FYI - I have troed Text() and Num#(), Num() with no success.

Thank you for or support..

Andrea

[anbu1984]

Can you attach sample file

[anbu1984]

Try this

Load Your_Amt_col+0 from Table

[iamthefixer · Accepted solution]

Anbu, thank you for reply.

What does Your_Amt_col+0 mean

Andrea

[JonnyPoole]

What do you have set at the top of the load script for these 2 variables ?  Ensure they are set correctly for your data format

SET ThousandSep=',';

SET DecimalSep='.';

As long as those are set you can use round() to remove any decimals in the load script.  num() doesn't remove decimals from the data model it just sets the display formatting.

change:

Load

     Numberfield

from <source>;

to:

Load

     round(Numberfield) as Numberfield

from <source>;

[iamthefixer]

Anbu,

I have foudn the solution: num(num#(FIELD))

Many thanks for your support.

Andrea