My text is getting set to a type of V-String and Size of 254 and I'm missing text. Does this mean the field is limited to 254 characters?
Also what is the character limit I can set for a v-string?
Thank you
Solved! Go to Solution.
Yes this mean the text is limited to 254 charracters.
There are a few places where the limit can be set. Assuming this is on a CSV input tool then there is a Field Iimit setting in the configuration:
Various other tools will also limit the length (e.g. Regex tool in parse mode)
if you set the limit to 10,000 (an example), then you'll get v_Wstrings created.
so if, like @jdunkerley79 shows you, you set the length to a very large number then Alteryx will create the fields with the appropriate data type.
Cheers,
Mark
How to handle field length when we use Excel? I am not getting any option like field length like csv as you mention.