Home / Questions / 497617
Accepted
Huntzberger
Asked: 2022-04-17 13:03:35 +0800 CST 2022-04-17 13:03:35 +0800 CST

Array inside another by id

  • 772

I have the following arrays:

//data
    [
    {
      "idAgen":36,
      "asesor":"ARCANGEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291
      },
      {
      "idAgen":67,
      "asesor":"MIGUEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":888
      },
      {
      "idAgen":90,
      "asesor":"JOSE",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291
      }
     ]

//pronostico
    [
      {
      "idAgen": 36, 
      "pronostico": 410693
      },
      {
      "idAgen": 36, 
      "pronostico": 8347
      },
      {
      "idAgen": 67, 
      "pronostico": 9877
      },
      {
      "idAgen": 67, 
      "pronostico": 9000
      },
      {
      "idAgen": 67, 
      "pronostico": 5363
      },
      {
      "idAgen": 90, 
      "pronostico": 896
      }
    ]

And what I'm trying to do is the following (for each data object):

    [
    {
      "idAgen":36,
      "asesor":"ARCANGEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291,
      "pronostico":[
        {
        "pronostico": 410693  
        },
        {
        "pronostico": 8347 
        }  
        ]
      }
     ]

I've tried this but it doesn't work, it adds the values ​​separately, like so:

    //data
    [
    {
      "idAgen":36,
      "asesor":"ARCANGEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291
      },
      { 
      "pronostico": 410693
      },
      { 
      "pronostico": 8347
      }
    ]

First I iterate both arrays, I start with forecast since it is bigger than data, then I iterate data, where the idAgen property is the same in both, add the forecast values ​​with push.


        for (var i = 0; i < pronostico.length; i++) 
         {
          for (var j = 0; j < data.length; j++) {
            if (pronostico[i]['idAgen'] == data[j]['idAgen'])
            {
              data.push({pronostico :pronostico[i]['pronostico']});  
            }
          }        
        }
        console.log(JSON.stringify(data));
javascript

1 Answers

  1. Best Answer

    I'm not a JavaScript expert; and I suppose there is some more basic or beautiful method; but in theory what you want to do is add a property with an array of objects to the data object.

    I would implement the following, two forEachand a validation and assignment of values ​​to the property:

    let json_str1 = JSON.parse(' [{"idAgen":36,"asesor":"ARCANGEL","idRegion":3,"region":"U","idZona":3,"zona":"ARIO","campos":291},{"idAgen":67,"asesor":"MIGUEL","idRegion":3,"region":"U","idZona":3,"zona":"ARIO","campos":888},{"idAgen":90,"asesor":"JOSE","idRegion":3,"region":"U","idZona":3,"zona":"ARIO","campos":291}]');

//console.log(json_str1);

let json_str2 = JSON.parse('[{"idAgen":36,"pronostico":410693},{"idAgen":36,"pronostico":8347},{"idAgen":67,"pronostico":9877},{"idAgen":67,"pronostico":9000},{"idAgen":67,"pronostico":5363},{"idAgen":90,"pronostico":896}]');

//console.log(json_str2);

json_str1.forEach((currentValue, key, data)=>{

  let tempObject=[];
  
  json_str2.forEach((currentValue2, key2, data2)=>{
  
    if(data[key].idAgen == data2[key2].idAgen){
      let value = data2[key2].pronostico;
      let object = {"pronostico":value};
      tempObject.push(object);
    }
    
  });
  
  if(tempObject.length>0){
    json_str1[key].pronostico=tempObject;
  }
  
});

console.log(json_str1);

    documentation on forEach

    Another method that can also be used is with: Object.entries and cyclesfor

    let json_str1 = JSON.parse(' [{"idAgen":36,"asesor":"ARCANGEL","idRegion":3,"region":"U","idZona":3,"zona":"ARIO","campos":291},{"idAgen":67,"asesor":"MIGUEL","idRegion":3,"region":"U","idZona":3,"zona":"ARIO","campos":888},{"idAgen":90,"asesor":"JOSE","idRegion":3,"region":"U","idZona":3,"zona":"ARIO","campos":291}]');

//console.log(json_str1);

let json_str2 = JSON.parse('[{"idAgen":36,"pronostico":410693},{"idAgen":36,"pronostico":8347},{"idAgen":67,"pronostico":9877},{"idAgen":67,"pronostico":9000},{"idAgen":67,"pronostico":5363},{"idAgen":90,"pronostico":896}]');

for (const [key, data] of Object.entries(json_str1)) {
  let tempObject=[];
  for (const [key2, data2] of Object.entries(json_str2)) {
   
    if(data.idAgen == data2.idAgen){
      let value = data2.pronostico;
      let object = {"pronostico":value};
      tempObject.push(object);
    }
  }
  if(tempObject.length>0){
    json_str1[key].pronostico=tempObject;
  }
}

console.log(json_str1);

    • 1