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?
