Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Cell text is truncated when importing a csv

ac5a
6 - Meteoroid

Hi, 

 

I am currently trying to run a csv through designer with a notes section, however, whenever the workflow runs the notes are truncated. 

 

The output is also truncated and no longer contains all the text. 

 

I have attached my workflow, please advise. 


Thanks!

3 REPLIES 3
jdunkerley79
ACE Emeritus
ACE Emeritus

When you import a CSV Alteryx defaults the field length to 254 characters. You can change this in the Input tool

2019-02-02_22-59-07.jpg

 

If you increase this it should be fine

Hedge29
6 - Meteoroid

Dear jdunkerley79,

 

Would you have any suggestions for when your solution does not work?

 

Hedge29_0-1591271100137.png

 

With these settings, I still get truncated characters in my data.

 

Thank in advance for your help!!

 

Kind regards,

 

Hedge29

 

Hedge29
6 - Meteoroid

Hi all,

 

There likely isn't a problem at all, as I read in the below post:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Data-truncation-problem-in-CSV-TXT-fil...

 

Apparently characters were only truncated in the data preview, not in the data itself.

 

Thanks!

Labels