Suffix doesn´t work in left join

[ramgouveia]

I've used this code

df_COMPARA <- df_CONV %>%
  left_join(agg_df_DATA_SOURCE, by = c("PAIS_COD", "NC2"), suffix = c("_ASSIM_NEGATIVAS", "_DATA_SOURCE_4_5_6"))

but it doesn't puts the suffix on the variables. What might be happening?

[JackDavison]

Hi Rui,

It's difficult to diagnose your problem without a reproducible example.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

Your syntax looks like it should do the job:

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union

dat <-
  tibble(id = 1:3,
         name = c("Andy", "Bob", "Charlie"))

left_join(dat, dat, by = "id", suffix = c("_lhs", "_rhs"))
#> # A tibble: 3 × 3
#>      id name_lhs name_rhs
#>   <int> <chr>    <chr>   
#> 1     1 Andy     Andy    
#> 2     2 Bob      Bob     
#> 3     3 Charlie  Charlie

^{Created on 2023-05-17 with reprex v2.0.2}