Input tool json field truncated- how to solve

I'm having a problem with a field being truncated when loaded into Alteryx.

My input is from postgres database, and I have a json field that I want to parse later but it gets truncated at 256 characters.

The input tool shows the field length option when I use a csv as input but not when my input is directly from the database.

Can someone help me with that?

Thank you in Advance

Input

Parse

Accepted answers

HossC

Hello @Beenish,

I believe the maximum character length for a PostGres ODBC inputs is determined when the connection is set up. Can you try editing your connection with these steps?

1. Click on the Datasource option

PostGres 1.png

2. Increase Max Varchar to a suitable value for your data.

PostGres 2.png

All comments

HossC

Hello @Beenish,

I believe the maximum character length for a PostGres ODBC inputs is determined when the connection is set up. Can you try editing your connection with these steps?

1. Click on the Datasource option

PostGres 1.png

2. Increase Max Varchar to a suitable value for your data.

PostGres 2.png

Beenish

Thank you so much. This solved the issue.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703