Dynamically iterate through a json array and add to another array

Question

I have a large array of json objects, that I need to iterate through and add them to another json array.

The array looks like the following -

{
  id : 1,
  name : "test1",
  location : "London",
  cost: "120.83"
},
{
  id : 2,
  name : "test2",
  location : "shanghai",
  cost: "124.83"
},
{
  id : 3,
  name : "test3",
  location : "Barcelona",
  cost: "56.54"
}

The actual array that im using has 73 key, value pairs, and about 20000 objects.

I am trying to transpose each individual object into another array, that needs to look like -

{
  cells: 
    [
       {
         value: 1,
         textAlign: "center",
         background: "rgb(255,255,255)",
         color: "rgb(0,62,117)"
       },
       {
         value: "test1",
         textAlign: "center",
         background: "rgb(255,255,255)",
         color: "rgb(0,62,117)"
       },
       {
         value: "London",
         textAlign: "center",
         background: "rgb(255,255,255)",
         color: "rgb(0,62,117)"
       },
       {
         value: "120.83",
         textAlign: "center",
         background: "rgb(255,255,255)",
         color: "rgb(0,62,117)"
       },
    ]
},
{
  cells: 
    [
       {
          value: 2,
          textAlign: "center",
          background: "rgb(255,255,255)",
          color: "rgb(0,62,117)"
       },
       {
          value: "test2",
          textAlign: "center",
          background: "rgb(255,255,255)",
          color: "rgb(0,62,117)"
       },
       {
          value: "shanghai",
          textAlign: "center",
          background: "rgb(255,255,255)",
          color: "rgb(0,62,117)"
       },
       {
          value: "124.83",
          textAlign: "center",
          background: "rgb(255,255,255)",
          color: "rgb(0,62,117)"
       },
   ]
},

I just cant get my head around it, it must be the monday fog!

Thanks

how do they relate to each other? please add a consitent example. — Nina Scholz
– Nina Scholz, Commented Feb 25, 2019 at 12:28
When giving example input & expected output, make it valid. It stops all the questions later. Looking at your input & output, I've a feeling you have put 1 too many items in the input example. — Keith
– Keith, Commented Feb 25, 2019 at 12:29
@NinaScholz they are related, op is mapping each value of each object to a element in calls array — Code Maniac
– Code Maniac, Commented Feb 25, 2019 at 12:36
the actual fields and values are irrelevant for this example, its just the actual way of transposing i am after. — sam smith
– sam smith, Commented Feb 25, 2019 at 12:48

jo_va · Accepted Answer · 2019-02-25 14:26:43Z

1

You can do it with Array.map() and Object.values():

const data = [
  { id : 1, name : "test1", location : "London", cost: "120.83" },
  { id : 2, name : "test2", location : "shanghai", cost: "124.83" },
  { id : 3, name : "test3", location : "Barcelona", cost: "56.54" }
];

const cell = { textAlign: 'center', background: 'rgb(255,255,255)', color: 'rgb(0,62,117)' };

const result = data.map(x =>
  ({ cells: Object.values(x).map(v => ({ value: `${v}`, ...cell })) })
);

console.log(result);

edited Feb 25, 2019 at 14:26

answered Feb 25, 2019 at 13:30

jo_va

14.1k3 gold badges25 silver badges49 bronze badges

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

Comments

Mohammad Usman · Accepted Answer · 2019-02-25 12:34:29Z

0

You can use .map() and Object.assign() methods:

const data = [
  {id : 1, name : "test1", location : "London", cost: "120.83"},
  {id : 2, name : "test2", location : "shanghai", cost: "124.83"},
  {id : 3, name : "test3", location : "Barcelona", cost: "56.54"}
];

const obj = {
  textAlign: "center",
  background: "rgb(255,255,255)",
  color: "rgb(0,62,117)"
};

const result = data.map(o => ({
   cells: Object.keys(o).map(k => Object.assign({}, {value: o[k]}, obj))
}));

console.log(result);

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

answered Feb 25, 2019 at 12:34

Mohammad Usman

39.6k20 gold badges99 silver badges101 bronze badges

Comments

Code Maniac · Accepted Answer · 2019-02-25 12:37:59Z

0

You can use map and reduce

let arr = [{id:1,name:"test1",location:"London",cost:"120.83"},{id:2,name:"test2",location:"shanghai",cost:"124.83"},{id:3,name:"test3",location:"Barcelona",cost:"56.54"}]

let defaultObject = {textAlign: "center",background: "rgb(255,255,255)",color: "rgb(0,62,117)" }

let op = arr.map(e => Object.values(e).reduce((op,inp) => {
    op.cells.push({value: inp, ...defaultObject } )
    return op
  },{cells:[]})
)

console.log(op)

edited Feb 25, 2019 at 12:37

answered Feb 25, 2019 at 12:31

Code Maniac

37.9k5 gold badges44 silver badges65 bronze badges

Collectives™ on Stack Overflow

Dynamically iterate through a json array and add to another array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related