converting columns to insert as rows in db

[SR2210]

Hi, 

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

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

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

Appreciate your help! Thanks

[manodwhb · Accepted solution]

@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