Combine Object base on object property in array on objects

Question

I just want to merge the objects on the base of one of the properties also want to add missing Days name in the output.

Take this for an example:

var array =  [
       {
      "heure1": "14:00",
      "heure2": "17:00",
      "day": "Sunday",
    },
       {
      "heure1": "08:00",
      "heure2": "13:00",
      "day": "Sunday",
    },
       {
      "heure1": "14:00",
      "heure2": "16:00",
      "day": "Monday",
    },
       {
      "heure1": "08:00",
      "heure2": "18:00",
      "day": "Monday",
    },
  ];

Expected result:

var array =  [
       {
      "heure": ["14:00","17:00","08:00","13:00"],
      "day": "Sunday",
    },
     {
      "heure": ["14:00","16:00","08:00","18:00"],
      "day": "Monday",
    },
    {
      "heure": [],
      "day": "Saturday",
    },
    {
      "heure": [],
      "day": "Friday",
    },
    {
      "heure": [],
      "day": "Thursday",
    },
    {
      "heure": [],
      "day": "Wednesday",
    },
    {
      "heure": [],
      "day": "Tuesday",
    },

  ];

Im also trying some of stack overflow answers but Not getting success :-( Order of the day dose not matter. Thanks in advance.

BTW, that is a strange order of days in your desired output... What is the logic? — trincot
– trincot, Commented Aug 10, 2020 at 17:45

mysterious · Accepted Answer · 2020-08-10 18:31:28Z

1

My try

<script>
    var array = [{
            "heure1": "14:00",
            "heure2": "17:00",
            "DAY": "Sunday",
        },
        {
            "heure1": "08:00",
            "heure2": "13:00",
            "DAY": "Sunday",
        },
        {
            "heure1": "14:00",
            "heure2": "16:00",
            "DAY": "Monday",
        },
        {
            "heure1": "08:00",
            "heure2": "18:00",
            "DAY": "Monday",
        },
    ];
    var days = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Sunday", "Saturday"];
    var result = [];
    days.map(function (day) {
        var daysInArray = array.filter(function (a) {
            return day == a.DAY
        })
        // console.log(daysInArray);
        if (daysInArray.length) {
            time = [];
            daysInArray.map(function (item, i) {
                for (var key in item) {
                    if (daysInArray[0].hasOwnProperty(key) && key != "DAY") {
                        time.push(item[key])
                    }
                }
            })
            result.push({
                "day": day,
                "heure": time
            })
        } else {
            result.push({
                "day": day,
                "heure": []
            })
        }
    })
    console.log(result);
</script>

answered Aug 10, 2020 at 18:31

mysterious

1,4786 gold badges29 silver badges58 bronze badges

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

2 Comments

osama somy Over a year ago

Thank you so much this is more dynamic then others and also very easy to understand.

Mister Jojo Over a year ago

@osamasomy this verifies the adage: why want to keep it simple when you can do it complicated ...

trincot · Accepted Answer · 2020-08-10 17:53:15Z

1

You could first create the 7 entries for the 7 days of the week, each with an empty array for the heure property.

Then iterate the original data, look up the right entry, and push the two times to the heure array.

Note that your Day property has different spellings in your example input (DAY, Day). I would strongly suggest to use all lowercase for such property names.

Here is an implementation:

var array =  [{"heure1": "14:00","heure2": "17:00","day": "Sunday",}, {"heure1": "08:00","heure2": "13:00","day": "Sunday",}, {"heure1": "14:00","heure2": "16:00","day": "Monday",}, {"heure1": "08:00","heure2": "18:00","day": "Monday", },];

let days = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"];
let obj = Object.fromEntries(days.map(day => [day, { heure: [], day }]));
for (let {heure1, heure2, day} of array) obj[day].heure.push(heure1, heure2);
let result = Object.values(obj);

console.log(result);

answered Aug 10, 2020 at 17:53

trincot

357k38 gold badges282 silver badges338 bronze badges

6 Comments

trincot Over a year ago

What about this answer? Does it suit your needs?

osama somy Over a year ago

Yes this is very help full but one of the guy send me more dynamic answer. by the Thanks for fast response I really appreciate. Thanks.

trincot Over a year ago

I don't see how that is more dynamic, but OK. Note it iterates the input several times, this solution only iterations the input once.

osama somy Over a year ago

His answer not depend on the key values like heure1 if some data is changed, I think it should work.

osama somy Over a year ago

by the way I really appreciate your Answer as well.

|

Mister Jojo · Accepted Answer · 2020-08-10 18:25:30Z

1

my way...

var arr_1 = 
    [ { heure1: '14:00', heure2: '17:00', day: 'Sunday' } 
    , { heure1: '08:00', heure2: '13:00', day: 'Sunday' } 
    , { heure1: '14:00', heure2: '16:00', day: 'Monday' } 
    , { heure1: '08:00', heure2: '18:00', day: 'Monday' } 
    ] 

const days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday']

const res = days.map(d=>
        {
        let r = { heure:[], day:d }
        arr_1.filter(x=>x.day===d)
             .forEach(({heure1,heure2})=> { r.heure.push(heure1,heure2) })
        r.heure.sort() 
        return r
        })


console.log( res  )

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

edited Aug 10, 2020 at 18:25

answered Aug 10, 2020 at 18:19

Mister Jojo

22.9k6 gold badges28 silver badges45 bronze badges

Comments

Miguel García · Accepted Answer · 2020-08-10 18:20:02Z

Is that result structure necessary?

If not, modifying the result structure, you could do something like this:

const getHeureByDay = (heureArray) => {
  let result = {
    Sunday: { heure: [] },
    Monday: { heure: [] },
    Tuesday: { heure: [] },
    Wednesday: { heure: [] },
    Thursday: { heure: [] },
    Friday: { heure: [] },
    Saturday: { heure: [] },
  };
  
  heureArray.forEach((heureItem) => {
    Object.keys(heureItem).forEach((key) => {
      if (key !== "day") {
        result[heureItem.day].heure.push(heureItem[key]);
      }
    })
  });
  
  return result;
};

const heureArray = [
  {
    "heure1": "14:00",
    "heure2": "17:00",
    "day": "Sunday",
  },
  {
    "heure1": "08:00",
    "heure2": "13:00",
    "day": "Sunday",
  },
     {
    "heure1": "14:00",
    "heure2": "16:00",
    "day": "Monday",
  },
     {
    "heure1": "08:00",
    "heure2": "18:00",
    "day": "Monday",
  }
];

console.log(getHeureByDay(heureArray));

Collectives™ on Stack Overflow

Combine Object base on object property in array on objects

4 Answers 4

2 Comments

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related