Adding items from array into objects within another array

Question

I am currently looping through the data that I have, getting all values for a specific column and adding them to an array, then limiting it to only unique values.

I also have a reportSections array that needs to be dynamic based on how many items are currently in my date_group array. How can I loop through those arrays and add the values to the id and name objects within my reportSections array?

Ideally, I'm thinking there might contain some sort of for loop that can loop through the reportSections array and dynamically add the values inside the date_group and record_group arrays to the id and name objects, but not sure how that would work.

  var date_group = [];
  var record_date = [];
    var i;
    for (i = 0; i < data.length; i++) {
      date_group.push(data[i]['date group']);
      record_date.push(data[i]['record date']);
    }

    date_group = _.uniq(date_group);
    record_date = _.uniq(record_date);

  const reportSections = [
    {id: 'date_group1', name: 'record_date1'},
    {id: 'date_group2', name: 'record_date2'},
    {id: 'date_group3', name: 'record_date3'},
    {id: 'date_group4', name: 'record_date4'},
    {id: 'date_group5', name: 'record_date5'},
    {id: 'date_group6', name: 'record_date6'},
  ];

please add all data to the question and add a wanted result as well. — Nina Scholz
– Nina Scholz, Commented Apr 10, 2020 at 14:24
Do you have the guarantee that you can pair the way you want? What if you have you 7 unique dates but 8 unique records? — Al-un
– Al-un, Commented Apr 10, 2020 at 14:29
The way the data is set up, the data will pair with each other. So if there are 7 unique records, there will be 7 unique dates. — Rataiczak24
– Rataiczak24, Commented Apr 10, 2020 at 14:31
@Supercool. yes, reportSections would be initially empty. What is showing currently in reportSections in my question is the ideal structure of it after it would loop through the values in the date_group and record_date arrays. — Rataiczak24
– Rataiczak24, Commented Apr 10, 2020 at 14:38

M A Salman · Accepted Answer · 2020-04-10 15:56:16Z

1

Regarding making items unique im confused looking at your question but try this solution.

Use set for unique records

let data = [{
    "date group": "C",
    "record date": "13 Mar 20"
  },
  {
    "date group": "B",
    "record date": "11 Mar 20"
  },
  {
    "date group": "A",
    "record date": "11 Mar 20"
  },
  {
    "date group": "B",
    "record date": "12 Mar 20"
  },
  {
    "date group": "C",
    "record date": "11 Mar 20"


  }
]
let reportSections = [];
let dataGroups = new Set();
let recordDates = new Set();
data.forEach(item => {
  dataGroups.add(item['date group']);
  recordDates.add(item['record date'])
})
for (const [index, value] of [...dataGroups].entries())
  reportSections.push({
    id: value,
    name: [...recordDates][index]
  })
console.log(reportSections);

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

answered Apr 10, 2020 at 15:56

M A Salman

3,8302 gold badges14 silver badges28 bronze badges

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

1 Comment

Rataiczak24 Over a year ago

Yes, this works for me. Thank you very much for taking the time and for the help!

Collectives™ on Stack Overflow

Adding items from array into objects within another array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related