Merging The same specific json object in two different json arrays

Question

I would like to merge the same specific json object on two different json arrays dependent on an json data ID.

JSON Data Set 1

{
    "Product":[
                {
                "product_id": "123",
                "location_id": "222",
                "product_code": "abc",
                },
                {
                "product_id": "456",
                "location_id": "111",
                "product_code": "xyz",
                }
            ]
}

JSON Data set 2

{
    "Location":[

            {
                "location_id": 111,
                "location_name": "alpha"
            },
            {
                "location_id": 222,
                "location_name": "tango"
            }


        ]
}

The Results would be something like this

{
    "Product":[

                {
                    "product_id": "456",
                    "location_id": "111",
                    "product_code": "xyz",
                    "location_name": "alpha"
                },
                {
                    "product_id": "123",
                    "location_id": "222",
                    "product_code": "abc",
                    "location_name": "tango"
                }
            ]
}

So far this is the code I've done.

var finalJson = {};

                    _.each(_.keys(productArray,locationArray), function(key) {
                        finalJson[key] = _.flatten(_.zip(productArray[key], locationArray[key]));
                    });

                    console.log(finalJson);

Yes, the merge result should be based on the same location ID. — Jon Mateo
– Jon Mateo, Commented Nov 30, 2017 at 0:56
right, so var result = {Product: locationArray.map((location, index) => Object.assign(location, productArray.find(product => String(product.location_id) == String(location.location_id))))}; — Jaromanda X
– Jaromanda X, Commented Nov 30, 2017 at 0:58

ncardeli · Accepted Answer · 2017-11-30 00:56:48Z

2

A simple algorithm could be using nested loops to go through both arrays, like this:

let allProducts = [{
    "product_id": "123",
    "location_id": "222",
    "product_code": "abc",
  },
  {
    "product_id": "456",
    "location_id": "111",
    "product_code": "xyz",
  }
];


let allLocations = [

  {
    "location_id": 111,
    "location_name": "alpha"
  },
  {
    "location_id": 222,
    "location_name": "tango"
  }
];

let result = allProducts.map((product) => {
  let matchingLocation = allLocations.find((location) => {
    return location.location_id == product.location_id;
  });
  return Object.assign(product, matchingLocation);
})

console.log(result);

answered Nov 30, 2017 at 0:56

ncardeli

3,5022 gold badges25 silver badges27 bronze badges

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

1 Comment

Jon Mateo Over a year ago

Thanks this work well. Liked the simplicity of the code :)

charlietfl · Accepted Answer · 2017-11-30 01:41:44Z

1

Make a hashmap of the locations using location id as keys, then iterate the Product array

let arr1 = {
  "Product": [{
    "product_id": "123",
    "location_id": "222",
    "product_code": "abc",
  }, {
    "product_id": "456",
    "location_id": "111",
    "product_code": "xyz",
  }]
}

let arr2 = {
  "Location": [
    {
      "location_id": 111,
      "location_name": "alpha"
    }, {
      "location_id": 222,
      "location_name": "tango"
    }
  ]
}
let locIds= _.keyBy(arr2.Location, 'location_id');
_.each(arr1.Product, (o) => _.assign(o, locIds[o.location_id]));

console.log(arr1.Product)

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

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.4/lodash.min.js"></script>

edited Nov 30, 2017 at 1:41

answered Nov 30, 2017 at 1:27

charlietfl

172k14 gold badges125 silver badges154 bronze badges

Collectives™ on Stack Overflow

Merging The same specific json object in two different json arrays

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related