How to change data types after loading Excel data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
After reading Excel data, I want to change all fields to data type double
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want the workflow to do the change, not manually. Over time, the data input might have new fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
