How to change data types after loading Excel data

[L_Gordon]

After reading Excel data, I want to change all fields to data type double

[ShankerV]

hi @L_Gordon 

Please use the select tool.

Many thanks

Shanker V

[L_Gordon]

I want the workflow to do the change, not manually.  Over time, the data input might have new fields.

[ShankerV]

.

[L_Gordon]

my workflow had the manual changes, but when I loaded data with a new column, Alteryx read it as text and a later step failed when the workflow expected numbers.

[Felipe_Ribeir0 · Accepted solution]

Hi @L_Gordon 

If you are sure that the input fields will be numeric fields, you can use the multi field formula configured like this to change them to double.

But if Alteryx is understanding your fields as text fields, you probably have text characters inside of these columns that you need to clean before going on.

[L_Gordon]

Felipe,

I was going to do that, but in truth, 1 field should remain as text.  But, since I know what that field is, I can comfortably select that field and change it