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