Data type issue

[ysreenumba]

Hi All,

By default why alteryx taking v_string data type for numerical values while loading flat file data . it should be numeric right?

then how can i change data type v_string to numeric for numerical columns.

Thanks

Sreeni

[Thableaus · Accepted solution]

Hi @ysreenumba 

Are you using a CSV file?

If so, all values will be as v_string types. That's supposed to happen. CSV columns are all stored as strings.

Use AutoField tool and you'll be able to change all data types at once. 

Cheers,