Tips for Rearranging Columns in an Array of Objects

Question

Tips for Rearranging Columns in an Array of Objects

I have an array of objects that I need to rearrange the columns and add a static value to each one:

 var homes = [
        {
            "h_id": "3",
            "city": "Dallas",
            "state": "TX",
            "zip": "75201",
            "price": "162500"

        }, {
            "h_id": "4",
            "city": "Bevery Hills",
            "state": "CA",
            "zip": "90210",
            "price": "319250"
        },...
    ];

The desired format is as follows:

 var homes = [
        {
            "h_id": "3",
            "price": "162500",
            "zip": "75201",
            "city": "Dallas",
            "state": "TX",
            "staticValue":  "1234"
        }, {
            "h_id": "4",
            "price": "319250",
            "zip": "90210",
            "city": "Bevery Hills",
            "state": "CA",
            "staticValue":  "1234"
        },...
    ];

I have attempted this approach:

let data = homes.map(function(x) {
                                  return {h_id:x.h_id,
                                         price : x.price,
                                         zip : x.zip,
                                         city : x.city,
                                         state : x.state,
                                         staticValue : "1234"}
                                   });

However, the column order remains the same:

h_id,city,state,zip,price,staticValue

Instead of the desired order:

h_id,price,zip,city,state,staticValue

What could be causing this issue?

Edit

In reality, I am using this reordering method to send the object as a DataTable to a C# controller. Upon reaching the Controller, the ordering is correct. It seems that the map function used has functioned properly.

Here's a working example: jsfiddle.net/a6o8jbh9/1

javascript arrays angularjs object ecmascript-6

Answer 1

Answer №1

It is not possible to perform that action

An object represents an unordered collection of name/value pairs

If maintaining order is crucial, consider using arrays instead of objects.

The sequencing of object properties is non-standard in ECMAScript as well.

I am unsure why there is a need to rearrange the objects; they can be easily accessed by their property names. What benefits are expected from reordering?

Since the introduction of ES2015, methods have been implemented following specific guidelines for determining property order, with rare exceptions where order is chronological. Object property order relies on the type of properties and their values. Thus, order can be guaranteed.

A demonstration can be made with the use of the map function

var homes = [
        {
        "1abc": "162500",
            "h_id": "3",
            "city": "Dallas",
            "state": "TX",
            "zip": "75201"


        }, {
            "h_id": "4",
            "city": "Bevery Hills",
            "state": "CA",
            "zip": "90210",
            "1abc": "319250"
        }
    ];
let data = homes.map(function(x) {
                                  return {h_id:x.h_id,
                                         '1abc':x["1abc"],
                                         zip : x.zip,
                                         city : x.city,
                                         state : x.state,
                                         staticValue : "1234"}
                                   });
console.log(homes)

console.log(data)

The resulting output will appear like this

https://i.sstatic.net/Ar0Ln.png

https://i.sstatic.net/O1ATW.png

In the output, the order has changed. Following ES2015 standards, property order adheres to specific rules, thus reorder accuracy cannot always be ensured. It may work in some scenarios (if input matches defined rules), but not all cases.

Note: Considering your comment, it seems you require sending this object to a controller action to then execute a merge query. In such a case, the Json object's order should not impact operations. Your c# model binder possesses the ability to bind correctly with the controller object. If your controller logic is correct and interacts with the SP appropriately, adjusting Json property order would not resolve any issues.

Answer 2

It is not possible to perform that action

An object represents an unordered collection of name/value pairs

If maintaining order is crucial, consider using arrays instead of objects.

The sequencing of object properties is non-standard in ECMAScript as well.

I am unsure why there is a need to rearrange the objects; they can be easily accessed by their property names. What benefits are expected from reordering?

Since the introduction of ES2015, methods have been implemented following specific guidelines for determining property order, with rare exceptions where order is chronological. Object property order relies on the type of properties and their values. Thus, order can be guaranteed.

A demonstration can be made with the use of the map function

var homes = [
        {
        "1abc": "162500",
            "h_id": "3",
            "city": "Dallas",
            "state": "TX",
            "zip": "75201"


        }, {
            "h_id": "4",
            "city": "Bevery Hills",
            "state": "CA",
            "zip": "90210",
            "1abc": "319250"
        }
    ];
let data = homes.map(function(x) {
                                  return {h_id:x.h_id,
                                         '1abc':x["1abc"],
                                         zip : x.zip,
                                         city : x.city,
                                         state : x.state,
                                         staticValue : "1234"}
                                   });
console.log(homes)

console.log(data)

The resulting output will appear like this

https://i.sstatic.net/Ar0Ln.png

https://i.sstatic.net/O1ATW.png

In the output, the order has changed. Following ES2015 standards, property order adheres to specific rules, thus reorder accuracy cannot always be ensured. It may work in some scenarios (if input matches defined rules), but not all cases.

Note: Considering your comment, it seems you require sending this object to a controller action to then execute a merge query. In such a case, the Json object's order should not impact operations. Your c# model binder possesses the ability to bind correctly with the controller object. If your controller logic is correct and interacts with the SP appropriately, adjusting Json property order would not resolve any issues.

Answer 3

Answer №2

It is essential to correctly access the properties and rearrange them in the right order - ES6 offers valuable functionalities for achieving this:

const updatedData = homes.map(({ h_id, city, state, zip, price }) => ({ h_id, price, zip, city, state, staticValue: "1234" }));

Answer 4

It is essential to correctly access the properties and rearrange them in the right order - ES6 offers valuable functionalities for achieving this:

const updatedData = homes.map(({ h_id, city, state, zip, price }) => ({ h_id, price, zip, city, state, staticValue: "1234" }));

Tips for Rearranging Columns in an Array of Objects

Answer №1

Answer №2

Similar questions

The use of conditional statements in AngularJS, such as if-else statements

Having difficulty populating a selection box through an ajax request in Django

Using AJAX to submit a PHP form without refreshing the page

How can I efficiently pass a JavaScript object to a function using jQuery syntax?

Displaying two arrays using ng-repeat leads to an error

What is the best way to refresh updated .js files directly from the browser console?

I am looking to eliminate any special characters from a designated section of a string using Javascript

What are some effective methods for comparing two extremely large arrays in Ruby?

Exploring the Differences in Site Navigation: PHP/HTML, Ajax, and CSS/Javascript

What is the correct way to execute a jQuery trigger on a checkbox or radio button to simulate a user clicking on it?

React and Axios: Overcoming CORS Policy to Connect with Java/SpringBoot REST Backend Service

Exploring the depths of Master-Detail functionality with Ionic and Angular, unlocking nested

What is the best way to determine the length of an array using input from an HTML form?

Updating view model data in Knockout from a different view model can be achieved by using observable properties and

Implementing context menus on the Material-UI DataGrid is a straightforward process that can enhance the user experience

What is the best way to store the JSON data that is returned in a JavaScript function as a variable

Switch up your code and toggle a class on or off for all elements that share a specific class

Ensure Website Accessibility by Implementing Minimum Resolution Requirements

Exploring the depths of Vue.js: Maximizing potential with nested

The definition of Csrftoken is missing