Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center 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

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