changing from string to integer

[BillyL14]

Hi 

I am trying to change the values in a column from text to numerical, so string to int I understand. There is only values in some of the cells with the others empty and all the values >1, so at decimal places.

When I use the select tool to change the type, all the values go to zero and the others go to null. Is there any way of leaving the values as they are and leaving the other cells empty while being numerical? 

Thank you

[Jonathan-Sherman]

Hi @BillyL14,

Could you attach some sample data with an input and a desired output so we can see what you're looking to achieve?

Regards,

Jonathan

[johnemery · Accepted solution]

It sounds like you may just need to set the field to a DOUBLE type rather than an integer type.

I agree, though, that seeing what you're dealing with and what you want would be helpful.

[vizAlter · Accepted solution]

Hi @BillyL14 — Hope attached workflow will be helpful.

FYI, you need to filter the Null and Empty cells, then use a Formula tool with "Double" or "FixedDecimal" data type, and use a Union tool to get the desired output.

ToNumber([Field1])

[BillyL14]

@vizAlter @johnemery @Jonathan-Sherman 

thanks

changed them to double and it worked