How to change Mutiple Data type

Question

Hello All,

I am trying to change the data type for different fields. Please see the attached file for details and advice.

Thanks,

Example5.xlsx

afv2688 · Answer

Hello @Learner09 ,

Unless there is some kind of specific rule to apply, you will need to change them manually into the desired ones.

Another option would be if you had a file with the specific data type needed for each column.

Maybe the auto field tool can help you further on the changes needed.

Regards

Learner09 · Answer

@afv2688 Thanks for the help, but I know few columns V-String, a few double, and a few in Byte. The Solution you provided, changed all data types to one specific. Please suggest any other way so I can change the Data type according to the need.

Thanks,

afv2688 · Answer

Hello @Learner09 ,

You can do this with a multi field formula. Use the ToNumber([_CurrentField_]) formula and select that you want to change the data type.

This will perform the changes on all fields selected on the list.

Regards