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
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_])
Hi @M_6666
Please use the select tool which will help to convert the String type to Integer data type.
Many thanks
Shanker V
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.