Max data size for a column capped at 256 for a string coming from a database

[anshuppal8]

Hi,

I am pulling some data from a database that has a column where some of the string data points have more than 256 characters. When I run the workflow and the input data tool pulls the data, it truncates the data to a max of 256 but I cant find any way to change the data size before it pulls the data in the input data tool. 

How can I edit the incoming size of the column in the input data tool before the tool pulls the data?

[christine_assaad]

Hi @anshuppal8 , can you add a Browse tool or write the data to an output and see if it will still show as truncated?

[Qiu]

@anshuppal8 
I agree with @christine_assaad , it shows that the data is truncated but we can see the complete data in the Browse tool.

I can see the my mark "End" at the end of my test string.

[anshuppal8]

Hi Christine and Qui,

I have added a browse tool. My original question had stated 256 characters which you guys are correct but as you can see it is still cutting off the remaining values. The pattern continues but its being cut off and it has added a "->" on its own at the end. The input is still limiting it to 400 characters which is the size of the column when you look at its size using a select tool. 

[anshuppal8]

Bumping this as I still need help

[Pilsner]

Hello @anshuppal8 

I appreciate you may not be able to share the actual data, but could you let me know what file format/database you are connecting to? 

My initial instinct is that the input tool may be configured to only allow a max field length of 256. This isn't an option for all data inputs, but is present for some. For example, a CSV defaults to a field length of 254 (you can simply type over this value to increase it):

Please let me know if this is of an help.

Regards - Pilsner

[anshuppal8]

Hi Pilsner,

Yes, I am unable to share the data but I am using an ODBC connection to a database used by my company. I have checked everywhere but I do not see any options to change the size of the field before it is pulled from the database. 

[apathetichell]

1) add your browse before your select tool. Your select tool may be cutting off your data (have that --- it should warn you).

2) look in your ODBC 64 config at your driver to see if it is cutting off your data (you must tell use what driver you are using and what database if you want any help here).

3) confirm that there is data in your database beyond that character.

comparing a browse in-db vs an on-canvas browse would help diagnose a database vs canvas issue (ie if you can show that the same row/field has more characters in the database)

It is possible this is an Alteryx issue - but it is much more likely 1) the data does not go beyond that character. 2) you are cutting it off or 3) your driver is configured wrong for your data.