topic converting columns to insert as rows in db in Talend Studio

converting columns to insert as rows in db

SR2210 — Wed, 13 Nov 2019 12:51:03 GMT

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 — Thu, 14 Nov 2019 08:16:16 GMT

@SR2210 ,check the one.

to get Unpivot component

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