Extracting fileds from JSON file

[mks02]

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,

[Anonymous · Accepted solution]

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-w...)

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

[mks02]

Thanks @nthampi , it worked for me.