Creating a new table column based on data from another table

General
2

You can use tidyr::rows_update() function

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