ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community has implemented a new single sign-on experience. If you are having issues with your account, please review the FAQs.

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

nomeshwary
5 - Atom

Hi All,

 

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

 

clipboard_image_0.png

 

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

 

Thanks,

Nomeshwary

derekbelyea
12 - Quasar
Jonathan-Sherman
15 - Aurora
15 - Aurora

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?

 

clipboard_image_0.png

sbansal
7 - Meteor

Hi,

 

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

Labels