Why my text is not complete?

[wenjuanchen]

Hi everyone,

I am importing some text data from a database (suppose SQL), and I found that some of my text fields are not complete. When I go to the Alteryx Input tool, I do not see a "Field Length" choice. What should I do to make sure I get all the text?

Thank you so much.

[BenMoss · Accepted solution]

It's probably just a visual problem, try writing a line of data which contains the truncated string to an output file, say .csv and determine whether it is actually truncating.

Do you get any errors saying truncation is occurring when running the workflow?

[AliOmran]

Hey @BenMoss , I have the same problem and it's not a visual problem, please any suggestions?

[faisal9999]

Same problem facing.

[faisal9999]

my field length is 353 and I have increased field length but still getting truncated issue, mY whole string is not coming through.

[ChrisTX]

If you don't have field size issue in an Input tool, add a Browse tool.

In the results window, double-click a cell to see the Cell Viewer which will display all of the text Alteryx has for that row and column.  This is the only way to display all text.

Chris