How to validate datatypes of columns in csv file.

[Simi_M]

Hello,

I have a task to validate datatype of the columns and raise a flag if Numeric field is String. the file which I'm using is .CSV so when I import data into Alteryx, it by default picking that up in String format for all the columns. How can I sort out this problem .

Please help!!!

Regards,

Simi

[Simi_M]

thanks Jean.... I can not share the files that's a problem . 

Really appreciate your keenness to help!!!