You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-07-19 11:18:18

guptanittala
Member
3 posts

guptanittala said:

Want to change the structure of the json string in talend

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.

Last edited by guptanittala (2016-07-19 11:19:36)

Offline

#2 2016-07-20 08:32:41

xdshi
Talend Team


xdshi said:

Re: Want to change the structure of the json string in talend

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-07-21 12:52:49

guptanittala
Member
3 posts

guptanittala said:

Re: Want to change the structure of the json string in talend

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

Offline

#4 2016-07-21 12:55:49

guptanittala
Member
3 posts

guptanittala said:

Re: Want to change the structure of the json string in talend

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy