Pivot Array Field in Postgres Source

JoshMcNatt — Fri, 24 Jun 2022 19:34:37 GMT

I need to parse/pivot an array column into individual columns. The source is Postgres. I cannot get it to work as the fields are not fixed length

Re: Pivot Array Field in Postgres Source

OritA — Mon, 27 Jun 2022 06:56:05 GMT

Hi,
Looking at the documentation under the Postgres supported data type the array column are replicated as NCLOB and therefore it is not possible to define transformation rule on them. However for more detailed investigation and better undersanding of the need, we would recommend you to open a case in our support portal and include the table DDL and the task json with the transformation rule you are trying to define so we can see if there is any other way to achieve your need.

thank s& regards,

Orit

topic Pivot Array Field in Postgres Source in Qlik Replicate

Pivot Array Field in Postgres Source

Re: Pivot Array Field in Postgres Source