I'm having an issue with one of my input files. The file is comma delimited but is not coming over with quotes to retain a values position under a certain column.
For example
Food, Agricultural, and Environmental Sciences CCH6
Food, Agricultural, and Environmental Sciences should be in it's own column but the comma is allowing a portion of the text to be brought over into the three columns total since there are two commas in the text.
Is there a way to get alteryx to recognize that Food, Agricultural, and Environmental Sciences should all remain in one column?