Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Want to convert all string column to specific datatype base on data in column

5 - Atom

Hi All,


I have data in excel and all column's data type is string . let me explain below




if you see in screenshot zip column are also string i want to make column to specific datatype base on data in coulmn.


is there any logic which i could use to detect and change data type from string to date, number etc




Alteryx Partner
Alteryx Certified Partner
Alteryx Certified Partner

Are you looking to choose the column you want to change the data type for or have determined for you?

Have you tried using the Auto Field Tool?



7 - Meteor



you can use auto field to change the data types as per data in fields.AutoFilter.jpg