topic Extracting fileds from JSON file in Talend Studio

Extracting fileds from JSON file

mks02 — Thu, 05 Dec 2019 08:15:05 GMT

Hi All,

I have a input file with multiple JSON records as below. I need to load this file to DB tables.

{
"EmpEntry":[
{
"Id":"11",
"Name":"ABC",
"JoinDate":"2018-11-05",
"JoinType":"FUNCTION",
"Mngr":"AAAAAAAAA",
"DIV":[
{
"SNo":1,
"acN":"103",
"AMNT":"55000.00",
}
],
"SUBDIV":[
{
"SNo":7,
"acN":"211",
"AMNT":"5000.00",
},
{
"SNo":3,
"acN":"212",
"AMNT":"50000.00",
}
],
"status":"SUCCESS",
}
]
}

I am new to JSON file and in talend job, I have facing a scenario describe below:

For "Div" element, its "SUBDIV" records should display to seperate rows. DIV can have multiple SUBDIV entries in file.
Expected Output:

Id;Name;JoinDate;JoinType;mgr;DIV_Sno;DIV_ACN,DIV_AMNT;SUBDIV_Sno;SUBDIV_ACN,SUBDIV_AMNT;status
11;ABC;2018-11-05;FUNCTION;AAA;1;103;55000;7;211;5000;SUCCESS
11;ABC;2018-11-05;FUNCTION;AAA;1;103;55000;3;212;50000;SUCCESS

i.e. SUBDIV should be display in separate rows.

Thanks,

Re: Extracting fileds from JSON file

Anonymous — Thu, 05 Dec 2019 18:42:16 GMT

Hi,

I believe you are looking for below solution.

The component details are as shown below.

Solution courtesy goes to @rhall 🙂

(https://community.talend.com/t5/Design-and-Development/JSON-Array-values-to-Rows-is-there-a-better-way/td-p/52229)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Extracting fileds from JSON file

mks02 — Fri, 06 Dec 2019 06:19:28 GMT

Thanks @nthampi , it worked for me.