topic Re: unpivot in postgresql in Talend Studio

unpivot in postgresql

Anonymous — Wed, 22 Jun 2016 13:58:58 GMT

Hi,
I have a table in postgreSQL, that needs to be unpivoted (columns to be converted in to a rows) to create a dimension. Could anyone suggest me a methodology to adopt this requirement? Kindly help.

Re: unpivot in postgresql

Anonymous — Thu, 23 Jun 2016 08:25:55 GMT

Hi,
Could you please take a look at this KB article about:TalendHelpCenter:Converting columns to rows to see if it is what you are looking for?
Best regards
Sabrina

Re: unpivot in postgresql

_AnonymousUser — Thu, 23 Jun 2016 08:39:38 GMT

Hi,
Thanks for your reply. I see that article explains about unpivot. But it is from a file delimited and not from a db table. Is there anything I need to do additional from the steps mentioned in the article to connect from a db table rather a delimited file? Kindly confirm.

Re: unpivot in postgresql

Anonymous — Thu, 23 Jun 2016 10:03:34 GMT

Hi,
You can use a db table as your input source.
The workflow should be: tpostgreSQLinput-->tUnpivotRow-->tMap-->tLogrow.
Best regards
Sabrina

Re: unpivot in postgresql

_AnonymousUser — Fri, 24 Jun 2016 06:04:59 GMT

I will try and post the status. Thanks a lot.

Re: unpivot in postgresql

Anonymous — Fri, 24 Jun 2016 10:15:02 GMT

Hi,
Feel free to let us know if it is OK with you.
Best regards
Sabrina