Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

String getting truncated at length 254

preethisisaac
8 - Asteroid

Hi All,

I have a .csv file , in which I have a field data which is more than 500 in length, so in select tool I have used V_String (1000) , also tried using V_WString(1000), but still the field data gets truncated at  length 254.  Is this a limitation in Alteryx? Is there  a way to get the full string without getting truncated?

 

Thanks,

Preethi

4 REPLIES 4
rkapoor
Alteryx
Alteryx

@preethisisaac try setting your Input tool as follows:

RishiK_4-1608825205967.png

 

messi007
15 - Aurora
15 - Aurora

@preethisisaac,

 

Have you tried to change the length in input side?

Please see below:

 

messi007_0-1608825251484.png

 

Hope that helps,

 

Regards,

preethisisaac
8 - Asteroid

Thanks a lot !!! It worked.

messi007
15 - Aurora
15 - Aurora

@preethisisaac,

 

Happy to help, Happy analyzing 🙂

 

Regards,

Labels
Top Solution Authors