From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

converting columns to insert as rows in db

Highlighted
Six Stars

converting columns to insert as rows in db

Hi, 

 

Currently my source file (.json) is in this structure;

 

Capture.JPG

 

 

 

 

 

 

 

 

I need to insert into PostgreSQL in the following table structure;


Capture.JPG

 

 

 

 

 

Currently I'm stuck in tMap to map the input as screenshot below;

 

Capture.JPG

 

 

 

 

 

 

 

Appreciate your help! Thanks Smiley Happy

 


Accepted Solutions
Highlighted
Moderator

Re: converting columns to insert as rows in db

@SR2210 ,check the one.

 

to get Unpivot component

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

 

 Below link provide the details for version 7.1 of Talend but please note that its in deprecated state.

 

https://help.talend.com/reader/ZPQP8werSqVqJEBzSFsDkQ/IezVqj82QqzNfApv7VXS5g

 

Untitled.pngUntitled.pngUntitled.png

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post


All Replies
Highlighted
Eleven Stars

Re: converting columns to insert as rows in db

Need to unpivot It. Check comment from xdshi also

https://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/tac-p/161968/...
Regards
Abhishek KUMAR
Highlighted
Moderator

Re: converting columns to insert as rows in db

@SR2210 ,check the one.

 

to get Unpivot component

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

 

 Below link provide the details for version 7.1 of Talend but please note that its in deprecated state.

 

https://help.talend.com/reader/ZPQP8werSqVqJEBzSFsDkQ/IezVqj82QqzNfApv7VXS5g

 

Untitled.pngUntitled.pngUntitled.png

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog