Group data based on multiple keys in javascript

Question

Received JSON response

[{
    "name": "A1",
    "date": "2019-03-13",
    "comment": "xyz"
  },
  {
    "name": "A1",
    "date": "2019-03-13",
    "comment": "abc"
  },
  {
    "name": "B1",
    "date": "2019-03-13",
    "comment": "pqr"
  },
  {
    "name": "A1",
    "date": "2019-03-14",
    "comment": "mno"
  }
]

Expected output

[
  {
    "name": "A1",
    "date": "2019-03-13",
    "data": [
      {
        "name": "A1",
        "date": "2019-03-13",
        "comment": "xyz"
      },
      {
        "name": "A1",
        "date": "2019-03-13",
        "comment": "abc"
      }
    ],
    {
      "name": "A1",
      "date": "2019-03-14",
      "data": [
        {
          "name": "A1",
          "date": "2019-03-14",
          "comment": "mno"
        }
      ]
    },
    {
      "name": "B1",
      "date": "2019-03-13",
      "data": [
        {
          "name": "B1",
          "date": "2019-03-13",
          "comment": "pqr"
        }
      ]
    }
  ]

I want to create new javascript array which contains unique name & date and its respective data.

Can someone help me here?

Why the duplication of data?

mplungjan
– mplungjan

2019-03-13 13:43:30 +00:00
Commented Mar 13, 2019 at 13:43 — mplungjan
– mplungjan, Commented Mar 13, 2019 at 13:43

Hassan Imam · Accepted Answer · 2019-03-13 13:47:03Z

3

You can use array#reduce to group date based on the name & date in an object accumulator, then extract all values using Object.values().

let data = [{ "name": "A1", "date": "2019-03-13", "comment": "xyz" }, { "name": "A1", "date": "2019-03-13", "comment": "abc" }, { "name": "B1", "date": "2019-03-13", "comment": "pqr" }, { "name": "A1", "date": "2019-03-14", "comment": "mno" } ],
    result = Object.values(data.reduce((r,{name,date, comment}) => {
      r[name + "_" + date] = r[name + "_" + date] || {name, date, data: []};
      r[name + "_" + date].data.push({name,date,comment});
      return r;
    },{}));
console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Mar 13, 2019 at 13:47

Hassan Imam

22.6k6 gold badges45 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Krunal Shah Over a year ago

I took more time to post this question compare to your so quick response. Thanks a ton!!!

Nina Scholz · Accepted Answer · 2019-03-13 13:49:28Z

3

You could take an array for the wanted grouping and look for the object.

var data = [{ name: "A1", date: "2019-03-13", comment: "xyz" }, { name: "A1", date: "2019-03-13", comment: "abc" }, { name: "B1", date: "2019-03-13", comment: "pqr" }, { name: "A1", date: "2019-03-14", comment: "mno" }],
    groupBy = ['name', 'date'],
    grouped = data.reduce((r, o) => {
        var temp = r.find(p => groupBy.every(k => o[k] === p[k]));
        if (!temp) {
            r.push(temp = Object.assign(...groupBy.map(k => ({ [k]: o[k] })), { data: [] }));
        }
        temp.data.push(o);
        return r;
    }, []);

console.log(grouped);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Mar 13, 2019 at 13:49

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Comments

ttulka · Accepted Answer · 2019-03-13 13:55:28Z

2

You can use reduce to collect the values:

var input = [{
    "name": "A1",
    "date": "2019-03-13",
    "comment": "xyz"
  },
  {
    "name": "A1",
    "date": "2019-03-13",
    "comment": "abc"
  },
  {
    "name": "B1",
    "date": "2019-03-13",
    "comment": "pqr"
  },
  {
    "name": "A1",
    "date": "2019-03-14",
    "comment": "mno"
  }
]

var res = input.reduce((acc, {name, date, comment}) => {
    var found = acc.find(el => el.name === name && el.date === date);
    return found 
        ? found.data.push({name, date, comment}) && acc 
        : [...acc, {name, date, data: [{name, date, comment}]}];
}, []);

console.log(JSON.stringify(res));

edited Mar 13, 2019 at 13:55

answered Mar 13, 2019 at 13:49

ttulka

11k7 gold badges46 silver badges57 bronze badges

Comments

Aziz.G · Accepted Answer · 2019-03-13 15:12:17Z

an Easy way to do that :

const data = [{
    "name": "A1",
    "date": "2019-03-13",
    "comment": "xyz"
  },
  {
    "name": "A1",
    "date": "2019-03-13",
    "comment": "abc"
  },
   {
    "name": "A1",
    "date": "2019-03-13",
    "comment": "fffffffff"
  },
  {
    "name": "B1",
    "date": "2019-03-13",
    "comment": "pqr"
  },
   {
    "name": "B1",
    "date": "2019-03-13",
    "comment": "hhhhhhhhhhh"
  },
  {
    "name": "A1",
    "date": "2019-03-14",
    "comment": "mno"
  }
]


const res = data.reduce((all, acc) => {

  const found = all.find(o => o.name === acc.name && o.date === acc.date)

  if (found === undefined) {
    all.push(acc)
  } else {
    found.data = (found.data || []).concat(acc)
  }

  return all;

}, [])

console.log(res)

Collectives™ on Stack Overflow

Group data based on multiple keys in javascript

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related