根据dataweave 2.0中两列或更多列的比较，过滤和合并两个数组

%dw 2.0
output application/json

var customers1 = [
    {id: 1, name: "Alice", email: "alice@example.com"},
    {id: 2, name: "Bob", email: "bob@example.com"}
]

var customers2 = [
    {id: 2, name: "Robert", email: "robert@example.com"},
    {id: 3, name: "Charlie", email: "charlie@example.com"}
]

// 合并两个数组并根据id去重
var mergedCustomers = (customers1 ++ customers2) distinctBy $.id

// 输出合并后的结果
mergedCustomers

%dw 2.0
output application/json

var customers1 = [
    {id: 1, name: "Alice", email: "alice@example.com"},
    {id: 2, name: "Bob", email: "bob@example.com"}
]

var customers2 = [
    {id: 2, name: "Robert", email: "robert@example.com"},
    {id: 3, name: "Charlie", email: "charlie@example.com"}
]

// 使用reduce合并数组，根据id合并对象
var mergedCustomers = (customers1 ++ customers2) reduce ((customer, acc = []) -> 
    acc find {it.id == customer.id} match {
        case null -> acc << customer
        case existing -> acc replace existing with (existing ++ customer)
    }
)

// 输出合并后的结果
mergedCustomers