Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

what is the character limit

TimOzirsky
8 - Asteroid

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

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

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:

2017-11-14_16-56-58.jpg

 

Various other tools will also limit the length (e.g. Regex tool in parse mode)

TimOzirsky
8 - Asteroid
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
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
SureshBurra1982
7 - Meteor

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

 

 

Labels
Top Solution Authors