how to merge data based on conditional value

What you are describing is an update not a join, use dplyr::rows_update()

If you need more specific help, please provide a proper REPRoducible EXample (reprex) illustrating your issue.

1 Like