Alteryx Designer Desktop Discussions

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

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

Zeng1-
Atome

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?

 

 

 

3 RÉPONSES 3
Raj
Aurore

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

Zeng1-
Atome

😊

Zeng1-
Atome

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.

 

Étiquettes