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

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?

Input

Database Connection

Accepted answers

All comments

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.

0508-anshuppal8.yxzp

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703