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

Questions
1

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?

image
image1251×514 28.6 KB

image
image1599×899 131 KB

image
image1599×899 128 KB

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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“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”: “customer8@mail.de”,
“customerSince”: “2021-10-02T16:00:00.000Z”,
“region”: “Europe”,
“subregion”: “Northern Europe”
}
}
]

2

Hey there!

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

Screenshot 2025-09-13 at 5.05.34 PM
Screenshot 2025-09-13 at 5.05.34 PM610×549 27.4 KB

Please mark this comment as Solution if it helped :slight_smile: