Excel Input

I'm trying to input an excel file but the data coming in has as many as fourteen decimal places. Easy enough, get rid of them in excel. Not so easy, that part is out of my hands. I get the file and have to make due. So, is there a way to bring in the file and have it either drop or round off the decimal places as I'm inputing the file. I did go into the SQL Editor and try Select FLOOR(*) from file. I need to select all because the file size can be random. THe FLOOR statement didn't work by the way. Any one else try this with better success?

Thanks!

Brad

Input

Accepted answers

jdunkerley79

One way I can think of is to use a MultiField formula to round all the values post the input tool or to change the type of all numeric fields to specified fixed decimal type, e.g.

Can you post a sample file?

jdunkerley79

When I tried in the multi formula didn't get any warnings on the truncation so might be worth a go.

All comments

cbridges

Have you tried using a select tool right after the input and setting the field type to integer? Haven't tested myself yet...

jdunkerley79

One way I can think of is to use a MultiField formula to round all the values post the input tool or to change the type of all numeric fields to specified fixed decimal type, e.g.

Can you post a sample file?

cbridges

That method should work, but I will let you know that you'll get warning messages about information being lost. That part can be a little annoying. I submitted an idea that we be given the ability to select "don't show again" for certain warning messages.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703