Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

String being truncated when loading data

AliOmran
6 - Meteoroid

Dears, I'm reading string column from Postgres DB and the column is huge one (actually it's JSON file saved in DB) but Alteryx has truncated the column even I put it like VW_String with big size like 9999999. Please any help?

3 REPLIES 3
TheOC
15 - Aurora
15 - Aurora

hi @AliOmran 

How are you inputting the data into the workflow?


Bulien
GaneshBo
Alteryx
Alteryx

Hi @AliOmran ,

 

Did you try out the solution posted in this thread?

Basically, you would have to change the maximum character length in the ODBC setting.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-tool-json-field-truncated-how-to...

 

Hope this helps!

 

Best,

Ganesh

AliOmran
6 - Meteoroid

Thanks for that, yeah it works.

Labels