unpivot in postgresql

unpivot in postgresql

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. 
Moderator

Re: unpivot in postgresql

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: unpivot in postgresql

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.
Moderator

Re: unpivot in postgresql

Hi,
You can use a db table as your input source.
The workflow should be: tpostgreSQLinput-->tUnpivotRow-->tMap-->tLogrow.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: unpivot in postgresql

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

Re: unpivot in postgresql

Hi,
Feel free to let us know if it is OK with you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.