topic Re: Parsing JSON with nested ID in Talend Studio

Parsing JSON with nested ID

laurbass — Thu, 25 Jun 2020 18:15:19 GMT

Hi. I would like to extract data from a json file and separate it by a given ID. I am looking at data from the United States and would like to separate it by state. the Json looks like this:

objs: {

{

location: {

id: "Alaska"

}

{policy1: "x"

policy2:"y"}

}

{

location: {

id: "Alabama"

}

{policy1: "x"

policy2: "z"

}

Is there a way to separate the data for each state using the nested location/id tag and then separate the data into separate files/workflows based on state?

Thanks.

Re: Parsing JSON with nested ID

root — Tue, 30 Jun 2020 14:38:43 GMT

Can you post the exact json please? This one what you have is not a valid json object

Re: Parsing JSON with nested ID

root — Tue, 30 Jun 2020 14:38:43 GMT

Can you post the exact json please? This one what you have is not a valid json object