The default (option 7 below) often causes problems with imports and is difficult for new users to find and I see no reason for the option to be so low. Can it be set higher to aid parsing of larger text fields e.g. parsing HTML files as text.
An alternative would be to add a warning that the data was truncated at the input stage.
I agree that a warning is needed that says the data was truncated in the input tool and to reset the field length..
@chris_love Where are you getting this Options window you've copied above? I'm trying work around this field character limit issue and do not see a Field length section in the configuration window. Same question for a simple text input tool, the character limit causes truncated data issue
@BlakeFox I believe you'll see a Field Length when you import it as csv.
This issue also affects the Crew Runner macro causing it to truncate the log entries at 254 characters. This post isn't a bug submission for that, but just to highlight how widespread the problem posted by the OP is and still ongoing years later. Maybe Alteryx can step up and fix a problem without putting it up to a "vote"? My hopes aren't up.