what is the character limit

[TimOzirsky]

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

[jdunkerley79 · Accepted 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)

[TimOzirsky]

Is there a specific field type to use that has a larger character limit?

Thanks,
Tim Ozirsky | Senior Manager, Customer Experience | Kronos Incorporated
tel: +1 978 947 4217 |

Kronos | Workforce Innovation That Works

Join Kronos on: kronos.com| Facebook | Twitter | LinkedIn | YouTube

[MarqueeCrew · Accepted solution]

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

[SureshBurra1982]

How to handle field length when we use Excel? I am not getting any option like field length like csv as you mention.