Create nested json from flattened JSON in javascript

Question

Started with javascript recently. I have a flattened json which looks like :

[
{"timestamp":"2019-01-01T00:00:00.000Z","MarketShare":89905.0,"Territory":"PHILADELPHIA PA"},
{"timestamp":"2019-01-01T00:00:00.000Z","MarketShare":82991.0,"Territory":"SEATTLE WA"},
{"timestamp":"2019-02-01T00:00:00.000Z","MarketShare":73662.0,"Territory":"PHILADELPHIA PA"},
{"timestamp":"2019-02-01T00:00:00.000Z","MarketShare":67059.0,"Territory":"SEATTLE WA"},
{"timestamp":"2019-03-01T00:00:00.000Z","MarketShare":72898.0,"Territory":"PHILADELPHIA PA"},
{"timestamp":"2019-03-01T00:00:00.000Z","MarketShare":68013.0,"Territory":"SEATTLE WA"},
{"timestamp":"2019-04-01T00:00:00.000Z","MarketShare":74607.0,"Territory":"PHILADELPHIA PA"},
{"timestamp":"2019-04-01T00:00:00.000Z","MarketShare":66769.0,"Territory":"SEATTLE WA"},
{"timestamp":"2019-05-01T00:00:00.000Z","MarketShare":93932.0,"Territory":"PHILADELPHIA PA"},
{"timestamp":"2019-05-01T00:00:00.000Z","MarketShare":86514.0,"Territory":"SEATTLE WA"}
]

Basically, for a given timestamp, I want to collect MarketShare and Territory under the result key.
The expected output is :

    [
   {
      "timestamp":"2019-01-01T00:00:00.000Z",
      "result":[
         {
            "MarketShare":89905.0,
            "Territory":"PHILADELPHIA PA"
         },
         {
            "MarketShare":82991.0,
            "Territory":"SEATTLE WA"
         },

      ]
   },
   {
      "timestamp":"2019-02-01T00:00:00.000Z",
      "result":[
         {
            "MarketShare":73662.0,
            "Territory":"PHILADELPHIA PA"
         },
         {
            "MarketShare":67059.0,
            "Territory":"SEATTLE WA"
         }
      ]
   },
   {
      "timestamp":"2019-03-01T00:00:00.000Z",
      "result":[
         {
            "MarketShare":72898.0,
            "Territory":"PHILADELPHIA PA"
         },
         {
            "MarketShare":68013.0,
            "Territory":"SEATTLE WA"
         }
      ]
   },
   {
      "timestamp":"2019-04-01T00:00:00.000Z",
      "result":[
         {
            "MarketShare":74607.0,
            "Territory":"PHILADELPHIA PA"
         },
         {
            "MarketShare":66769.0,
            "Territory":"SEATTLE WA"
         }
      ]
   },
   {
      "timestamp":"2019-05-01T00:00:00.000Z",
      "result":[
         {
            "MarketShare":93932.0,
            "Territory":"PHILADELPHIA PA"
         },
         {
            "MarketShare":86514.0,
            "Territory":"SEATTLE WA"
         }
      ]
   }
]

I am trying to create a generic utility that puts any number of key value pair under a given timestamp. The progress made so far:

topNFormat=[]
for(var i = 0; i < firstResult.length; i++) {
    //res = [firstResult[i]["Territory"]
    topNFormat[timestamp] = firstResult[i][timestamp] || {};
    topNFormat[result] = firstResult[i][result] || [];
    topNFormat[result].push(firstResult[i]);
    //return collection;
}

That's not [JSON](http://json.org) -> [What is the difference between JSON and Object Literal Notation?](https://stackoverflow.com/questions/2904131/what-is-the-difference-between-json-and-object-literal-notation) — Andreas, Dec 19 '19 at 11:04
Does this answer your question? [JavaScript array re structure](https://stackoverflow.com/questions/59302132/javascript-array-re-structure) — Nick Parsons, Dec 19 '19 at 11:40
^ using that appraoch you can do something like [this](https://jsfiddle.net/1qdgkwvp/) (simply `.push(r)` instead and extract the `timestamp` only (so `{parent_address, relationship, ...r}` becomes `{timestamp, ...r}` — Nick Parsons, Dec 19 '19 at 11:42

score 3 · Accepted Answer · answered Dec 19 '19 at 11:33

Here's a general purpose function transform that would group items dynamically:

const input = [{
    "timestamp": "2019-01-01T00:00:00.000Z",
    "MarketShare": 89905.0,
    "Territory": "PHILADELPHIA PA"
  },
  {
    "timestamp": "2019-01-01T00:00:00.000Z",
    "MarketShare": 82991.0,
    "Territory": "SEATTLE WA"
  },
  {
    "timestamp": "2019-02-01T00:00:00.000Z",
    "MarketShare": 73662.0,
    "Territory": "PHILADELPHIA PA"
  },
  {
    "timestamp": "2019-02-01T00:00:00.000Z",
    "MarketShare": 67059.0,
    "Territory": "SEATTLE WA"
  },
  {
    "timestamp": "2019-03-01T00:00:00.000Z",
    "MarketShare": 72898.0,
    "Territory": "PHILADELPHIA PA"
  },
  {
    "timestamp": "2019-03-01T00:00:00.000Z",
    "MarketShare": 68013.0,
    "Territory": "SEATTLE WA"
  },
  {
    "timestamp": "2019-04-01T00:00:00.000Z",
    "MarketShare": 74607.0,
    "Territory": "PHILADELPHIA PA"
  },
  {
    "timestamp": "2019-04-01T00:00:00.000Z",
    "MarketShare": 66769.0,
    "Territory": "SEATTLE WA"
  },
  {
    "timestamp": "2019-05-01T00:00:00.000Z",
    "MarketShare": 93932.0,
    "Territory": "PHILADELPHIA PA"
  },
  {
    "timestamp": "2019-05-01T00:00:00.000Z",
    "MarketShare": 86514.0,
    "Territory": "SEATTLE WA"
  }
];

const transform = (array, groupBy, groupUnder) => array.reduce((acc, object) => {
  if (groupBy in object) {
    if (object[groupBy] in acc) {
      acc[object[groupBy]][groupUnder] = [
        ...acc[object[groupBy]][groupUnder],
        ...[Object.keys(object).filter((key) => key !== groupBy).reduce((acc, key) => {
          acc[key] = object[key];

          return acc;
        }, {})]
      ]
    } else {
      acc[object[groupBy]] = {
        [groupUnder]: [Object.keys(object).filter((key) => key !== groupBy).reduce((acc, key) => {
          acc[key] = object[key];

          return acc;
        }, {})]
      }
    }
  }

  return acc;
}, {});

const groupBy = 'timestamp';
const groupUnder = 'result';

const transformedResult = transform(input, groupBy, groupUnder);

console.log(transformedResult);

console.log('-'.repeat(100));

console.log(Object.keys(transformedResult).map((key) => Object.assign({}, transformedResult[key], {
  [groupBy]: key
})));

Andy · Answer 2 · 2019-12-19T11:34:20.610

1

Here is the simple solution by using built-in reduce function:

[].reduce((memo, item) => {
    memo[item.timestamp] = memo[item.timestamp] ||
                          { timestamp: item.timestamp, result: [] };
    memo[item.timestamp].result.push({
       MarketShare: item.MarketShare,
       Territory: item.Territory 
    });
    return memo;
 }, {});

Update 2 (more generic)

[].reduce((memo, item) => {
    memo[item.timestamp] = memo[item.timestamp] ||
                          { timestamp: item.timestamp, result: [] };
    // push whole item into result list
    memo[item.timestamp].result.push({ ...item });
    return memo;
 }, {});

edited Dec 19 '19 at 11:34

answered Dec 19 '19 at 11:09

Andy

523
2
13

Thanks for promptly responding. yes, this will work but i would be needing something more generic. Apart from MarketShare and Territory new parameters like District, Country might be coming. – anarchy Dec 19 '19 at 11:29
do you need timestamp to be included as well into result object? if this doesn't matter for you simply use approach from update #2: – Andy Dec 19 '19 at 11:33

Create nested json from flattened JSON in javascript

2 Answers2

Linked