Alteryx Designer Desktop Discussions

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

limit exceeding 5000+ characters not fetching the whole cell content to the alteryx

vssrsairam
6 - Meteoroid

Hi All,

I have a column with characters limit exceeding 5000+ characters from CSV file. I tried changing the field size up to 20,000 for input tool and also changed the data type to V_WString. But the data is still coming half from the input tool itself 

 

Please Let me know is there any possibility to fetch the whole text

 

here this is the column looks like - 

PIC.jpg

 

Here the data is breaking from the input tool itself :-

alt.jpg

 

attaching the sample data with that column, Please let me know how to resolve this issue

4 REPLIES 4
MilindG
12 - Quasar

Add a browse tool, you should be able to see the data.

vssrsairam
6 - Meteoroid

but i need to clean up & fetch the data after the value: "------" ☹️

binuacs
20 - Arcturus

@vssrsairam your input data doesn't have any '--------' characters also im able to see the full data in the input file tool, 

 

binuacs_0-1680728867369.png

 

KavyaSri9
7 - Meteor

Preview always shows the first 100 records, adding Browse tool at the end shows all the data from the input.

 

KavyaSri9_0-1680743078759.png

 

Though there is warning sign, all the data is displayed

 

Labels