Question:

How to manipulate manipulating Array object in JavaScript?

Problem:

I have bellow array object

var datasource = [

{"Region": "America",

"Total_Time_Spent": "10",

"YearMonth": "2023 - October",

"projectname":"Project 1"},

{"Region": "America",

"Total_Time_Spent": "20",

"YearMonth": "2023 - October",

"projectname":"Project 2"},

{"Region": "America",

"Total_Time_Spent": "30",

"YearMonth": "2023 - June",

"projectname":"Project 3"},

{"Region": "Asia",

"Total_Time_Spent": "30",

"YearMonth": "2023 - June",

"projectname":"Project 4"}

]

based on the above I'm trying to create bellow array format

var Finaldatasource = [

{"Region": "America",

"YearMonth": "2023 - October",

"Project 1": "10",

"Project 2": "20",

"Project 3": "0",

"Project 4": "0"},

{"Region": "Asia",

"YearMonth": "2023 - October",

"Project 1": "0",

"Project 2": "0",

"Project 3": "0",

"Project 4": "0"}

{"Region": "America",

"YearMonth": "2023 - June",

"Project 1": "0",

"Project 2": "0",

"Project 3": "30",

"Project 4": "0"},

{"Region": "Asia",

"YearMonth": "2023 - June",

"Project 1": "0",

"Project 2": "0",

"Project 3": "0",

"Project 4": "30"}

]

means first two columns become Region and YearMonth followed by Project names as columns and value will be the hours spent

I have wrote bellow code and im able to get Region and followed by Project names as columns and value will be the hours spent. but how can also include YearMonth column

var Finaldatasource = [];

datasource.forEach(entry => {

let existingRegion = result.find(Region => Region.Region === entry.Region);

if (existingRegion) {

existingRegion[entry.projectname] = entry.Total_Time_Spent;

} else {

let newRegion = { "Region": entry.Region };

newRegion[entry.projectname] = entry.Total_Time_Spent;

result.push(newRegion);

}

});

// Add missing months and set their values to 0

var allMonths = Array.from(new Set(dataarray.map(entry => entry.projectname)));

result.forEach(Region => {

allMonths.forEach(month => {

if (!Region.hasOwnProperty(month)) {

Region[month] = 0;

}

});

Solution:

I've got what you are looking for. If you use es6, it can be done simply.

var datasource = [

{"Region": "America",

"Total_Time_Spent": "10",

"YearMonth": "2023 - October",

"projectname":"Project 1"},

{"Region": "America",

"Total_Time_Spent": "20",

"YearMonth": "2023 - October",

"projectname":"Project 2"},

{"Region": "America",

"Total_Time_Spent": "30",

"YearMonth": "2023 - June",

"projectname":"Project 3"},

{"Region": "Asia",

"Total_Time_Spent": "30",

"YearMonth": "2023 - June",

"projectname":"Project 4"}

];

var project = {

"Project 1": "0",

"Project 2": "0",

"Project 3": "0",

"Project 4": "0"

};

const newDataSource = datasource.reduce((res, current) => {

return [

...res,

{

"Region": current.Region,

"YearMonth": current.YearMonth,

...project,

[current.projectname]: current.Total_Time_Spent

}

];

}, []);

console.log(newDataSource)

Suggested blogs:

>Login to Laravel API- Laravel

>Make Xdebug stop at breakpoints in PhpStorm using Docker

>Creating a service in Laravel using app(FQCN)

>How to check null in jQuery?

>How is the value of the path column under the wagtailcore_page table populated?

>Why VSCode indicate an error on using {{ }}?

>Fix the python-decouple issue in Django

>Address the N+1 problem in Django with prefetch

>How can I retrieve all customers' bookings by their username/ID?

JavaScript

Ritu Singh

Your Answer

Submit

Ritu Singh

0 Answers

Top Questions

Ritu Singh

0 Answers

Top Questions

Related Questions