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 -
Here the data is breaking from the input tool itself :-
attaching the sample data with that column, Please let me know how to resolve this issue
Add a browse tool, you should be able to see the data.
but i need to clean up & fetch the data after the value: "------" ☹️
@vssrsairam your input data doesn't have any '--------' characters also im able to see the full data in the input file tool,
Preview always shows the first 100 records, adding Browse tool at the end shows all the data from the input.
Though there is warning sign, all the data is displayed