0

I have 2 arrays (rlT and refundT). I want to remove the duplicate items in the rlT array. All the items in the rlT array with the transactionId matching the transactionId of the items in the refundT array must be removed. I have a working code with filter() and find() by following the link: Remove all elements contained in another array. I want to implement the same functionality using Promise.all and find().

let refundT = [
    {
        "_id": "616149cfd0c4e7178757254f",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "9a493445",
        "processType": "Inbound",
        "transactionId": "a1ae05ce",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-09T07:50:39.104Z",
        "updatedAt": "2021-10-09T08:30:02.948Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "616138e1f5cdaf66bd455deb",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "712e27c9d17d6ab3",
        "processType": "Inbound",
        "transactionId": "23nea9r27cBz",
        "paymentMethod": "DCB",
        "transactionAmount": 25,
        "conversionWalletValue": 2500,
        "processStatus": "1",
        "channelName": "DCB",
        "respField01": "516337616341058476",
        "walletExpiry": "2021-10-14T06:38:25.581Z",
        "createdAt": "2021-10-09T06:38:25.501Z",
        "updatedAt": "2021-10-09T06:38:25.581Z",
        "__v": 0,
        "currentBalance": 26,
        "currentBalanceCoins": 2600
    },
    {
        "_id": "61601ba49d149212e6a465d3",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "a507f4a549489924",
        "processType": "Inbound",
        "transactionId": "1qqJk0XdZ1zO",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "1",
        "channelName": "DCB",
        "respField01": "516336886107955938",
        "walletExpiry": "2021-10-13T10:21:24.601Z",
        "createdAt": "2021-10-08T10:21:24.571Z",
        "updatedAt": "2021-10-08T10:21:24.602Z",
        "__v": 0,
        "currentBalance": 5,
        "currentBalanceCoins": 500
    },
    {
        "_id": "6160086eb371321df17e8e28",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "97187f4b",
        "processType": "Inbound",
        "transactionId": "e8292dd8",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "M",
        "createdAt": "2021-10-08T08:59:26.859Z",
        "updatedAt": "2021-10-08T10:30:00.499Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "616002116ddd8d16dfbd3bdb",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "5264ee47",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:32:17.065Z",
        "updatedAt": "2021-10-08T10:30:00.522Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "616001f96ddd8d16dfbd3bda",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "5dd468f8",
        "processType": "Inbound",
        "transactionId": "8634c9a4",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:31:53.548Z",
        "updatedAt": "2021-10-08T12:54:41.623Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "61600051942ddd0ce73d8730",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "784dc7bf",
        "processType": "Inbound",
        "transactionId": "7140c4a8",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:24:49.009Z",
        "updatedAt": "2021-10-08T12:54:41.665Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "615fff84942ddd0ce73d872f",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "1e069bc1",
        "processType": "Inbound",
        "transactionId": "557798c5",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:21:24.524Z",
        "updatedAt": "2021-10-08T12:54:41.684Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "615ffee8942ddd0ce73d872e",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "eeb8102d",
        "processType": "Inbound",
        "transactionId": "61049097",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:18:48.800Z",
        "updatedAt": "2021-10-08T12:54:41.693Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "615ffe76942ddd0ce73d872b",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "7d7c18ac",
        "processType": "Inbound",
        "transactionId": "38e63c72",
        "paymentMethod": "Online banking",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:16:54.399Z",
        "updatedAt": "2021-10-08T12:54:41.696Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    },
    {
        "_id": "615ffd43942ddd0ce73d872a",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "reloadOrderId": "9c2d02a0",
        "processType": "Inbound",
        "transactionId": "a4099cb1",
        "paymentMethod": "Online banking",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "2",
        "channelName": "MM",
        "createdAt": "2021-10-08T08:11:47.281Z",
        "updatedAt": "2021-10-08T13:30:00.048Z",
        "__v": 0,
        "errorCode": "-",
        "errorDescription": "Cron job EXPIRED the transaction"
    }
]
let rlT = [
    {
        "_id": "6161368fe775582a8a56b660",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "6ee3b80be60804d9",
        "processType": "Inbound",
        "transactionId": "2iTmr4gPyqL2",
        "paymentMethod": "DCB",
        "transactionAmount": 10,
        "conversionWalletValue": 1000,
        "processStatus": "3",
        "respField01": "516337610298568370",
        "createdAt": "2021-10-09T06:28:31.575Z",
        "updatedAt": "2021-10-09T06:28:31.575Z",
        "__v": 0
    },
    {
        "_id": "61613615e775582a8a56b65d",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "d419dac30da92876",
        "processType": "Inbound",
        "transactionId": "01XuNwWK7T11",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "respField01": "516337609079578348",
        "createdAt": "2021-10-09T06:26:29.535Z",
        "updatedAt": "2021-10-09T06:26:29.535Z",
        "__v": 0
    },
    {
        "_id": "616135bae775582a8a56b65a",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "a9739187c9f16c3b",
        "processType": "Inbound",
        "transactionId": "4DAT1sCgI78A",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "respField01": "516337608140338332",
        "createdAt": "2021-10-09T06:24:58.398Z",
        "updatedAt": "2021-10-09T06:24:58.398Z",
        "__v": 0
    },
    {
        "_id": "616008afb371321df17e8e2a",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "31ff569c4f94aefb",
        "processType": "Inbound",
        "transactionId": "e8292dd8",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92940",
        "createdAt": "2021-10-08T09:00:31.308Z",
        "updatedAt": "2021-10-08T09:00:31.308Z",
        "__v": 0
    },
    {
        "_id": "616005dc256d9f1c2f463c4c",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "206dc8760b30336e",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92932",
        "createdAt": "2021-10-08T08:48:28.263Z",
        "updatedAt": "2021-10-08T08:48:28.263Z",
        "__v": 0
    },
    {
        "_id": "6160056e7b4ede1be0b17994",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "c05f52ba6016ebe1",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92932",
        "createdAt": "2021-10-08T08:46:38.066Z",
        "updatedAt": "2021-10-08T08:46:38.066Z",
        "__v": 0
    },
    {
        "_id": "6160054dc8b3001baae803f5",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "189723181bc7236f",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92932",
        "createdAt": "2021-10-08T08:46:05.977Z",
        "updatedAt": "2021-10-08T08:46:05.977Z",
        "__v": 0
    },
    {
        "_id": "61600478a82ef91b223713d0",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "c517dbbe47182851",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92932",
        "createdAt": "2021-10-08T08:42:32.700Z",
        "updatedAt": "2021-10-08T08:42:32.700Z",
        "__v": 0
    },
    {
        "_id": "6160032de1605518303a778d",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "491951af5e824c64",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92932",
        "createdAt": "2021-10-08T08:37:01.441Z",
        "updatedAt": "2021-10-08T08:37:01.441Z",
        "__v": 0
    },
    {
        "_id": "616002f38a9da217fdfaf29e",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "4c249cf7085b9359",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "txnNo": "D92932",
        "createdAt": "2021-10-08T08:36:03.107Z",
        "updatedAt": "2021-10-08T08:36:03.107Z",
        "__v": 0
    },
    {
        "_id": "616002716ddd8d16dfbd3bdd",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "ffc9b8a6beeba0f5",
        "processType": "Inbound",
        "transactionId": "2d141956",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "4",
        "txnNo": "D92932",
        "errorCode": "0",
        "errorDescription": "Success",
        "createdAt": "2021-10-08T08:33:53.462Z",
        "updatedAt": "2021-10-08T08:33:53.462Z",
        "__v": 0
    },
    {
        "_id": "61600066942ddd0ce73d8732",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "a3ad562dae470c7f",
        "processType": "Inbound",
        "transactionId": "557798c5",
        "paymentMethod": "Credit/Debit card",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "4",
        "txnNo": "D92930",
        "errorCode": "0",
        "errorDescription": "Success",
        "createdAt": "2021-10-08T08:25:10.168Z",
        "updatedAt": "2021-10-08T08:25:10.168Z",
        "__v": 0
    },
    {
        "_id": "615ffed6942ddd0ce73d872d",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "24f1ab09cf9a0dff",
        "processType": "Inbound",
        "transactionId": "38e63c72",
        "paymentMethod": "Online banking",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "4",
        "txnNo": "MH92922",
        "errorCode": "1",
        "errorDescription": "Failed",
        "createdAt": "2021-10-08T08:18:30.778Z",
        "updatedAt": "2021-10-08T08:18:30.778Z",
        "__v": 0
    },
    {
        "_id": "615ffbfa942ddd0ce73d8728",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "44659dab5701ad5e",
        "processType": "Inbound",
        "transactionId": "b66292aJ2d3a",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "respField01": "516336804968754530",
        "createdAt": "2021-10-08T08:06:18.520Z",
        "updatedAt": "2021-10-08T08:06:18.520Z",
        "__v": 0
    },
    {
        "_id": "615ffbf1942ddd0ce73d8725",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "414c92d467cabd92",
        "processType": "Inbound",
        "transactionId": "12Xo212z6n01",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "respField01": "516336804856904527",
        "createdAt": "2021-10-08T08:06:09.003Z",
        "updatedAt": "2021-10-08T08:06:09.003Z",
        "__v": 0
    },
    {
        "_id": "615ffb4e942ddd0ce73d8722",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "6afd27ae07297062",
        "processType": "Inbound",
        "transactionId": "0F14mCe1bmLV",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "respField01": "516336803248314498",
        "createdAt": "2021-10-08T08:03:26.138Z",
        "updatedAt": "2021-10-08T08:03:26.138Z",
        "__v": 0
    },
    {
        "_id": "615ffb3e942ddd0ce73d871f",
        "epmId": "615ff4a8836c1b2d46a353f8",
        "referenceId": "168c0f1b70919ecb",
        "processType": "Inbound",
        "transactionId": "9003kMf1628N",
        "paymentMethod": "DCB",
        "transactionAmount": 5,
        "conversionWalletValue": 500,
        "processStatus": "3",
        "respField01": "516336803064324494",
        "createdAt": "2021-10-08T08:03:10.895Z",
        "updatedAt": "2021-10-08T08:03:10.895Z",
        "__v": 0
    }
]
let myArray1 = rlT.filter(ar => !refundT.find(rm => (rm.transactionId === ar.transactionId) ))
console.log(myArray1.length)

I tried the Promise.all() as below:

let result = await Promise.all( 

    rlT.map(async(element) => {
        let dup = refundT.find((e) => {
            console.log('dup', e.transactionId, element.transactionId)
            return e.transactionId == element.transactionId
        })
        if(dup){
            console.log('kkkk')
        }
       // console.log('dup', dup)
       
    })
    )

I am able to find the duplicates, but not successful in removing the duplicate items from the rlT array.

krishna kurtakoti
  • 128
  • 9

2 Answers2

1

If both arrays have been fetched, this can be done synchronously. filter returns all of the elements of an array meeting a test. In the OP case, the test is whether the element id is not found in the refund array.

let result = rlT.filter(t => {
  return !refundT.find(r => r.transactionId === t.transactionId)
});
danh
  • 62,181
  • 10
  • 95
  • 136
0

You may also consider using a hash table if the list are very large.

const m = new Map();
rlT.forEach(t => m.set(t.transactionId, t));
refundT.forEach(t => m.delete(t.transactionId));

console.log(Array.from(m.keys()))
console.log(Array.from(m.values()))
Brandon Mosher
  • 76
  • 4