Dataset setting | Merge

You can learn about joining relational data here : 13 Relational data | R for Data Science (had.co.nz)
Otherwise; we would need more info to advise you.

about your rename issue; its clear from the error that Q2 is a mere list, and not one that is a data.frame which is what rename is designed to operate on.

Here is a link to our reprex guide for if you want to provide examples of your start data.

1 Like