String being truncated when loading data

[AliOmran]

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?

[TheOC]

hi @AliOmran 

How are you inputting the data into the workflow?

[GaneshBo · Accepted solution]

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]

Thanks for that, yeah it works.