0

Hi I have 3 tibbles called 'A', 'B' and 'C', each has a column entitled 'Area' and some additional columns. I am looking to merge all 3 in to one tibble that has joins on 'Area' and keeps the other columns.

I have tried, can anyone correct please?

Testertable <- merge(A, B, C, by "Area")

Testertable  <- full_join(A,  B, C, by = "Area")
JeffWithpetersen
  • 137
  • 11
  • 1
    Use two steps, first join B on A and then C on the result of the first join. (i.e. `Testertable <- A %>% full_join(B) %>% full_join(C)` (since the common columns all have the same name we might not need to specify the `by` argument) – dario Oct 20 '21 at 09:52
  • 1
    Refer https://stackoverflow.com/questions/32066402/how-to-perform-multiple-left-joins-using-dplyr-in-r/32066419 – Nad Pat Oct 20 '21 at 10:00

0 Answers0