join_many_to_many_inspect: Inspect which rows cause a many-to-many warning

In retodomax/FunRZ: Useful functions

Inspect which rows cause a many-to-many warning

Description

Inspect which rows cause a many-to-many warning

Usage

join_many_to_many_inspect(x, y, by = NULL, show_rows = c("none", "x", "y"))

Arguments

x	see dplyr::inner_join()
y	see dplyr::inner_join()
by	see dplyr::inner_join()
show_rows	character, show the rows which cause the problem in table x or y. If none it returns a counting table how often a certain joining-key is observed in x and y.

Value

tbl with number of multiple observed joining keys, or rows which cause the problem in table x or y

Examples

x <- tibble(key = c(1, 1:3),
value = letters[key])
y <- tibble(key = c(1,1,1,1,2),
            value2 = 1:5)
x %>% inner_join(y)
join_many_to_many_inspect(x = x, y = y, show_rows = "none")
join_many_to_many_inspect(x = x, y = y, show_rows = "x")

retodomax/FunRZ documentation built on July 4, 2025, 10:43 p.m.