community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Meteor

Hi,

 

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

Labels