Compare two Arrays and remove the block from one array if certain data exists in both arrays

Question

I need to compare two arrays that have different data fields in them. The comparison is based on lets say Id number and if data matches in the two arrays, I need to remove the whole block/row from the array. For example, in the below arrays, I need to compare OrderId(from Array1) and SystemId(from Array2) and if the Ids match the whole block needs to be removed from Array1. Please see sample arrays and output below:

Array1 = [
  {
    "OrderId": "00111111",
    "BillingCountry": "GB",
    "CurrencyIsoCode": "GBP",
    "PersonEmail": "[email protected]"   
  },
  {
    "OrderId": "00222222",
    "BillingCountry": "US",
    "CurrencyIsoCode": "USD",
    "PersonEmail": "[email protected]"     
  }
] 

Array2 = [
  {
    "SystemId": "00111111" 
  },
  {
    "SystemId": "00333333" 
  },
  {
    "SystemId": "00444444" 
  }
] 

Output:   [
    {
        "OrderId": "00222222",
        "BillingCountry": "US",
        "CurrencyIsoCode": "USD",
        "PersonEmail": "[email protected]"     
      }
]

aled · Accepted Answer · 2023-10-31 02:19:44Z

0

I believe for these kind of problem using the Arrays module some() function express the intention clearly.

%dw 2.0
output application/json
import some from dw::core::Arrays

var Array1 = [
  {
    "OrderId": "00111111",
    "BillingCountry": "GB",
    "CurrencyIsoCode": "GBP",
    "PersonEmail": "[email protected]"   
  },
  {
    "OrderId": "00222222",
    "BillingCountry": "US",
    "CurrencyIsoCode": "USD",
    "PersonEmail": "[email protected]"     
  }
] 

var Array2 = [
  {
    "SystemId": "00111111" 
  },
  {
    "SystemId": "00333333" 
  },
  {
    "SystemId": "00444444" 
  }
] 
---
Array1 filter ((item) -> not (Array2 some ($.SystemId == item.OrderId)))

Output

[
  {
    "OrderId": "00222222",
    "BillingCountry": "US",
    "CurrencyIsoCode": "USD",
    "PersonEmail": "[email protected]"
  }
]

answered Oct 31, 2023 at 2:19

aled

26.5k4 gold badges36 silver badges52 bronze badges

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

Comments

StackOverflowed · Accepted Answer · 2023-10-31 05:16:46Z

0

Simply done, like below:

%dw 2.0
output application/json
import * from dw::core::Arrays
var Array1 = [
  {
    "OrderId": "00111111",
    "BillingCountry": "GB",
    "CurrencyIsoCode": "GBP",
    "PersonEmail": "[email protected]"   
  },
  {
    "OrderId": "00222222",
    "BillingCountry": "US",
    "CurrencyIsoCode": "USD",
    "PersonEmail": "[email protected]"     
  }
] 

var Array2 = [
  {
    "SystemId": "00111111" 
  },
  {
    "SystemId": "00333333" 
  },
  {
    "SystemId": "00444444" 
  }
] 

---
Array1 filter !(Array2.SystemId contains $.OrderId)

answered Oct 31, 2023 at 5:16

StackOverflowed

7593 silver badges7 bronze badges

Collectives™ on Stack Overflow

Compare two Arrays and remove the block from one array if certain data exists in both arrays

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related