Convert excel data fields from text to number with no decimal places

[M_6666]

Hi, Any help would be appreciated.

I have an excel file input in Alteryx.and various columns should be numbers. One column has come across as a date format and others text. How do I convert these to number? Thank you

[caltang]

You can use the Multi-Field Formula tool under the Preparation tab. Select all your fields which you want to convert to numbers.

Tick the "Change data type to...." and choose your data type of choice. You can choose Double if you'd like.

Use this:

ToNumber([_CurrentField_])

[ShankerV]

Hi @M_6666 

Please use the select tool which will help to convert the String type to Integer data type.

Many thanks

Shanker V

[caltang]

If you'd like for us to show you, kindly provide some sample data and we can share the workflow with you so that you can see it and learn as well.