The warning message is fairly clear: if you expect that your join will have a many-to-many relationship, add
relationship="many-to-many"
as an argument to the join. You have several calls to
left_join
in your function, try it in any or all of them. The reason that is there because many newer programmers do not recognize what will happen when there is not a clear 1-to-1 or 1-to-many relationship, and are really really confused when the number of rows in the results
multiplies a lot. This is a safeguard, a warning. —
r2evans 49 secs ago