use Alteryx workflow to export data from PostgreSQL, but it lost some Json data.

[Zeng1-]

Dear teams, hope you are doing well.

Now I use Alteryx workflow to export data from PostgreSQL, but it lost some Json data.

How could I resolve it？

[Raj]

@Zeng1- 
please elaborate as the provided information is very less to understand the issue you are facing.

[Zeng1-]

😊

[Zeng1-]

Dear,

 For example. As below.

The right data is {"acs": "2022-09-29", "bi": "2022-08-06", "ta": "2022-11-07", "cool": "2022-10-02", "her": "2022-11-07", "sw": "2022-08-20", "oil": "2022-10-02", "rad": "2022-12-01", "crimp": "2022-09-29", "cas": "2022-08-03", "wire": "2022-08-21", "bending": "2022-10-13", "oiling": "2023-02-15", "body": "2022-08-31", "body2": "2023-02-06", "oiling": "2023-02-19", "op": "2022-07-31", "packing": "2022-10-29", "ssembly": "2022-11-14", "test": "2023-04-27", "wind": "2022-10-10"}

But it would lost some Json data if I exported data using Alteryx. It is {"acs": "2022-09-29", "bi": "2022-08-06", "ta": "2022-11-07", "cool": "2022-10-02", "her": "2022-11-07", "sw": "2022-08-20", "oil": "2022-10-02", "rad": "2022-12-01", "crimp": "2022-09-29", "cas": "2022-08-03", "wire": "2022-08-21", "bending": "2022-10-13", "oiling": "2023-02-15", "bo

The data sources is PostgreSQL.

[Raj]

@Zeng1- 
you need to increase the filed length

this should solve your problem
mark done if solved.

[apathetichell]

check out your odbc driver for field limits. Can you confirm you see that in an export (ie a file) - with an extended field length. and do you see the truncation in a browse tool? can you share a screen grab? Is this in-db or on canvas?