I load a large CSV file into a workflow. There are numerous string fields in the CSV, moving from left to right, followed by 4 fields of values, and with one string field at the right end. When I look at the metadata for the input data, all fields are appearing as VString fields.
Do I need to be concerned about this, or will the values in the fields shown as VString be properly treated as values? Do I need to use the ToNumber function on all of the value fields? I tried that, but in the output from the formula the numeric fields still appear as VString.
I'm relatively new to Alteryx and appreciate any input as I develop my ways of working.
Solved! Go to Solution.
Thank you. A more experienced coworker also suggested that I use the Select Tool rather than a formula. I just changed the field type in the Select Tool to Double and everything seems OK now.