Level 2 - Workflow 1: Merging data (Only one row is updated)

[Brixy_Brix]

Describe the problem/error/question: How can I ensure that all columns for region and subregion are updated? It seems that only one row was updated.

What is the error message?

Please share your workflow

Share the output returned by the last node

[
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Europe”,
“subregion”: “Western Europe”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Asia”,
“subregion”: “Southern Asia”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Oceania”,
“subregion”: “Australia and New Zealand”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Europe”,
“subregion”: “Eastern Europe”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Americas”,
“subregion”: “North America”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Americas”,
“subregion”: “South America”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Americas”,
“subregion”: “Caribbean”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Europe”,
“subregion”: “Western Europe”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Asia”,
“subregion”: “Eastern Asia”
}
},
{
“id”: “rec0jyNfA5un3olXe”,
“createdTime”: “2025-09-10T06:46:22.000Z”,
“fields”: {
“customerID”: “8”,
“customerCountry”: “Germany”,
“customer Email”: “[email protected]”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Europe”,
“subregion”: “Northern Europe”
}
}
]

[krisn0x]

Hey there!

Can you try updating your last node as follows? It’s not currently set to match (find) records by ID:

Please mark this comment as Solution if it helped