Question 281966 in Jquery Question posted in
The official Jquery Api Documentation can be found here.

Jquery – Filter array to remove the duplicate records based on multiple columns

Below is the input array I have:

let inputArr = [
    {
        "supplierId": "1",
        "baseSupplierId": "71277",
        "supplierName": "Supplier 1",
        "partNumber": "4018992",
        "partDescription": "Description 1"
    },
    {
        "supplierId": "2",
        "baseSupplierId": "71277",
        "supplierName": "Supplier 2",
        "partNumber": "4018992",
        "partDescription": "Description 2"
    },
    {
        "supplierId": "3",
        "baseSupplierId": "71277",
        "supplierName": "Supplier 3",
        "partNumber": "4019030",
        "partDescription": "Description 3"
    },
    {
        "supplierId": "4",
        "baseSupplierId": "71277",
        "supplierName": "Supplier 4",
        "partNumber": "4018291",
        "partDescription": "Description 4"
    },
    {
        "supplierId": "5",
        "baseSupplierId": "71277",
        "supplierName": "Supplier 5",
        "partNumber": "4018992",
        "partDescription": "Description 5"
    }
]

And I want to have an array as output which will have unique values based on column "baseSupplierId" and "partNumber" and also if there are multiple records with the same "baseSupplierId" and "partNumber" then get only the first one and remove other duplicates.

So I want the ouput array as follows:

let outputArr = [
        {
            // This is the item that had multiple records with the same "baseSupplierId" and "partNumber" and now only one should come in output
            "supplierId": "1",
            "baseSupplierId": "71277",
            "supplierName": "Supplier 1",
            "partNumber": "4018992",
            "partDescription": "Description 1"
        },
        {
            "supplierId": "3",
            "baseSupplierId": "71277",
            "supplierName": "Supplier 3",
            "partNumber": "4019030",
            "partDescription": "Description 3"
        },
        {
            "supplierId": "4",
            "baseSupplierId": "71277",
            "supplierName": "Supplier 4",
            "partNumber": "4018291",
            "partDescription": "Description 4"
        }
    ]
Tags:

2

Answers


  1. 0

    Use a set to get uniqueness

    Then chain all relevant fields

    let uniqueCombinations = new Set();
let outputArr = [];

for (let item of inputArr) {
    let combination = item.baseSupplierId+ "#SOME_SEPARATOR#" + item.partNumber;

    if (!uniqueCombinations.has(combination)) {
        outputArr.push(item);
        uniqueCombinations.add(combination);
    }
}

    Insert into output array if not exist in set.

    Login or Signup to reply.
  2. 0

    You could convert (using Array.prototype.reduce()) to new Map() (by unique property) and then extract the Map’s .values() :

    const inputArr = [
  {"supplierId": "1","baseSupplierId": "71277","supplierName": "Supplier 1","partNumber": "4018992","partDescription": "Description 1"},
  {"supplierId": "2","baseSupplierId": "71277","supplierName": "Supplier 2","partNumber": "4018992","partDescription": "Description 2"},
  {"supplierId": "3","baseSupplierId": "71277","supplierName": "Supplier 3","partNumber": "4019030","partDescription": "Description 3"},
  {"supplierId": "4","baseSupplierId": "71277","supplierName": "Supplier 4","partNumber": "4018291","partDescription": "Description 4"},
  {"supplierId": "5","baseSupplierId": "71277","supplierName": "Supplier 5","partNumber": "4018992","partDescription": "Description 5"},
];


const outputMap = inputArr.reduce((m, item) => (
  !m.has(item.partNumber) && m.set(item.partNumber, item), m
), new Map());

console.log([...outputMap.values()]);
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search