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

[nomeshwary]

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

Thanks,

Nomeshwary

[derekbelyea]

This discussion from last year addresses this question:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-Change-A-Field-Type/m-p/33...

[Jonathan-Sherman]

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

[graceelizabethalissa]

Have you tried using the Auto Field Tool?

[sbansal]

Hi,

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