Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

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

Highlighted
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

Highlighted
Alteryx Partner
Highlighted
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?

Highlighted

Have you tried using the Auto Field Tool?

 

clipboard_image_0.png

Highlighted
7 - Meteor

Hi,

 

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

Labels