title: Merging Unequal dataframes showing all NA values instead of actual values
body: <p>I'm having trouble merging two unequal data frames. Trying to do a left join and the right table is resulting in all NA values when joined by 'Id' and 'date'. I tried the below but wasn't successful. Structures are all the same.</p>
  <pre><code>Date = m/d/y
  Left Table:
  id  Date       V1  V2  V3
  1   4/13/2022  42  69  99
  2   4/10/2022  32  58  44
  3   3/15/2022  12  23  95
  4   3/10/2022  84  42  63
  
  Right Table:
  id  Day        X1  X2 
  1   4/13/2022  10  9
  2   4/09/2022   8  7
  3   3/15/2022   6  5
  
  
  left_right_merged &lt;- merge(
     x = left_table, 
     y = right_table, 
     by.x = c(&quot;id&quot;, &quot;date&quot;), 
     by.y = c(&quot;id&quot;, &quot;day&quot;), 
     all.x= TRUE
  )       
                                                                                   
  
  Expected:
  Id  Date       V1  V2  V3  X1  X2
  1   4/13/2022  42  69  99  10   9
  2   4/09/2022  NA  NA  NA   8   7
  2   4/10/2022  32  58  44  NA  NA
  3   3/15/2022  12  23  95   6   5
  4   3/10/2022  84  42  63  NA  NA
  
  Actual:
  Id  Date       V1  V2  V3  X1  X2
  1   4/13/2022  42  69  99  NA  NA
  2   4/09/2022  NA  NA  NA  NA  NA
  2   4/10/2022  32  58  44  NA  NA
  3   3/15/2022  12  23  95  NA  NA
  4   3/10/2022  84  42  63  NA  NA
  </code></pre>