unpivot in postgresql

[Anonymous]

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. 

[Anonymous]

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

[_AnonymousUser]

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.

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

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