I guess the settings are: Operation - Update Data Mode - Map Each Column Below
Then I choose the key column and value
In Values to Send I choose the column and what to send. But this works only for the 1st found row, not for all of them. See the Update operation for Max Sendak. Only the 1st country was updated, not the 2nd one,
BTW, the Update node outputs empty data, which is useless. Would be nice to have at least some success message or other useful info,
There’s no such a operation like VLOOKUP right now, as far as I know.
The problem is that Update operation works only with the 1st row matching. And it ignores rest of the matching rows.
Suppose you want to change all “Michael” names to Mike. The Update operation will change only the 1st Michael, leaving all other Michaels unaltered.