Want to change the structure of the json string in talend

[Anonymous]

I want to change the structure of the json string from single array format to sub array format.
And will try on several ways but all were failed,
I tried with Meta data -->File Json (Customised component) (Present on the left side panel)
Please suggest me suitable component for my requirement.

[Anonymous]

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

[Anonymous]

Previously it was like this.
"Company Id" : 5399,
    "Company Name" : "1-800 Contacts",
    "Employee Id" : 265849,
    "First Name" : "Evan",
    "Last Name" : "Lambson",
    "Title" : "Software Engineer",
    "Seniority Level" : "Engineer",
    "Reports To" : "Chris Wilsher",
    "Email" : " elambson@1800contacts.com",
    "Direct Phone" : "(801) 316-7758",
    "City" : "Draper",
    "State" : "UT",
    "Country" : "United States",
    "LinkedIn URL" : "",
    "Website" : " www.1800contacts.com",
    "Revenue (Mil)" : 255,
    "IT Budget (Mil)" : 0,
    "Number of Employees" : 1135,
    "IT Employees" : 57


and i want like this .



   "Company Id" : 5399,
   "Company Name" : "1-800 Contacts",
   "Employee Id" : 265849,
   "Website" : " www.1800contacts.com",
   "Revenue (Mil)" : 255,
   "IT Budget (Mil)" : 0,
   "Number of Employees" : 1135,
   "IT Employees" : 57
   Employees : [{
      First Name" : "Evan",
   "Last Name" : "Lambson",
   "Title" : "Software Engineer",
   "Seniority Level" : "Engineer",
   "Reports To" : "Chris Wilsher",
   "Email" : " elambson@1800contacts.com",
   "Direct Phone" : "(801) 316-7758",
   "City" : "Draper",
   "State" : "UT",
   "Country" : "United States",
   "LinkedIn URL" : ""},
    {
    First Name" : "Gupta",
   "Last Name" : "nittala",
   "Title" : "Software Engineer",
   "Seniority Level" : "Engineer",
   "Reports To" : "Chris Wilsher",
   "Email" : " elambson@1800contacts.com",
   "Direct Phone" : "(801) 316-7758",
   "City" : "Draper",
   "State" : "UT",
   "Country" : "United States",
   "LinkedIn URL" : ""
   }]



actually employee-id be per employee

[Anonymous]

i want to group the employee details means i want all of the employees in one array in which those are belonging to one company
similarly if i have 10 companies in my json string i want to get 10 arrays in that i need all the employees belonging to that company..