Sort Array Objects by Key Based on Another Array

Question

I have an array called "sortOrder" in which i expect to use as the model order i want to sort my "dataSet" array with.

const sortOrder = [
           "FirstName",
           "LastName",
           "Address", 
           "City", 
           "State", 
           "Zip", 
           "Country" ]

const dataSet = [
         { Zip: "00199", 
           City: "Birmingham",
           State: "AL", 
           LastName: "Ellis", 
           Country: "USA",
           FirstName: "Dominique",
           Address: "127 East Avenue J St",
         },
         { Zip: "95421", 
           City: "San Francisco",
           State: "CA", 
           LastName: "Orlando", 
           Country: "USA",
           FirstName: "Mitchell",
           Address: "90 Market Street Unit 2",
         },
         { Zip: "DN11 5XQ", 
           City: "Wadworth",
           State: "AL", 
           LastName: "Connolly", 
           Country: "UK",
           FirstName: "John",
           Address: "130  New Dover Rd",
          }
         ]

Goal: To have something like the below object ordered based on keys found in the "sortOrder" array:

     { FirstName: "Dominique",
       LastName: "Ellis",
       Address: "127 East Avenue J St",
       City: "Birmingham",
       State: "AL",
       Zip: "00199",
       Country: "USA" }

I've tried to use sort method to handle the sort but its not working. Any advice on how to get this dataset sorted by the key?

My failed attempt:

    dataSet.sort((a, b) => {
         return sortOrder.indexOf(a) - sortOrder.indexOf(b);
    });

    console.log("SortedDataSet", dataSet);

Do you really need to use a sort function? I guess that you could accomplish what you want with a map. — danibrum
– danibrum, Commented Dec 9, 2020 at 4:22

Ketan Ramteke · Accepted Answer · 2020-12-09 05:26:26Z

2

const sortOrder = [
  "FirstName",
  "LastName",
  "Address",
  "City",
  "State",
  "Zip",
  "Country"
]

let dataSet = [{
Zip: "00199",
City: "Birmingham",
State: "AL",
LastName: "Ellis",
Country: "USA",
FirstName: "Dominique",
Address: "127 East Avenue J St",
  },
  {
Zip: "95421",
City: "San Francisco",
State: "CA",
LastName: "Orlando",
Country: "USA",
FirstName: "Mitchell",
Address: "90 Market Street Unit 2",
  },
  {
Zip: "DN11 5XQ",
City: "Wadworth",
State: "AL",
LastName: "Connolly",
Country: "UK",
FirstName: "John",
Address: "130  New Dover Rd",
  }
]

let solution = dataSet.map(data => {
  let obj = {}
  for (let key of sortOrder) {
obj[key] = data[key];
  }
  return obj
})

console.log(solution)

edited Dec 9, 2020 at 5:26

answered Dec 9, 2020 at 4:45

Ketan Ramteke

10.7k2 gold badges27 silver badges46 bronze badges

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

4 Comments

MsNichols Over a year ago

not the desired result. This doesnt sort.

Ketan Ramteke Over a year ago

can you give the original input with its corresponding sorted output.

MsNichols Over a year ago

Its what i posted in my question - i even gave an example of the sample output/goal @Ketan Ramteke - i want the dataSet array sorted in the same order as the sortOrder Array.

MsNichols Over a year ago

i. shoouldve known map was the direction to go. Thank you, this worked!

YATIN GUPTA · Accepted Answer · 2020-12-09 05:34:19Z

const dataSet = [
         { Zip: "00199", 
           City: "Birmingham",
           State: "AL", 
           LastName: "Ellis", 
           Country: "USA",
           FirstName: "Dominique",
           Address: "127 East Avenue J St",
         },
         { Zip: "95421", 
           City: "San Francisco",
           State: "CA", 
           LastName: "Orlando", 
           Country: "USA",
           FirstName: "Mitchell",
           Address: "90 Market Street Unit 2",
         },
         { Zip: "DN11 5XQ", 
           City: "Wadworth",
           State: "AL", 
           LastName: "Connolly", 
           Country: "UK",
           FirstName: "John",
           Address: "130  New Dover Rd",
          }
         ];

const sortOrder = [
           "FirstName",
           "LastName",
           "Address", 
           "City", 
           "State", 
           "Zip", 
           "Country" ];

let sortedDataSet = [];
dataSet.forEach((d) => {
    let entry = {};
    sortOrder.forEach((s) => {
        entry[s] = d[s];
    });
    sortedDataSet.push(entry);
});

console.log('Original Dataset');
console.log(dataSet);
console.log('Sorted Dataset');
console.log(sortedDataSet);

Collectives™ on Stack Overflow

Sort Array Objects by Key Based on Another Array

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related