Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
12 - Quasar

hi @AliOmran 

How are you inputting the data into the workflow?

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