renaming of auxiliary columns

[moodymudskipper]

Especially useful for recursive joins.

We might use a glue like syntax :

power_left_join(list("{col}_from_df1" = df1, "df2_{col}" = df2), by = whatever)

this is more flexible that the suffix argument, and also redundant but we kind of need suffix for compatibility with dplyr.

[moodymudskipper]

https://stackoverflow.com/questions/69965129/how-to-use-full-join-reduce-on-multiple-datasets-and-have-custom-suffixes

[moodymudskipper]

https://stackoverflow.com/questions/65152352/suffixes-when-merging-more-than-two-data-frames-with-full-join/67645673#67645673

[moodymudskipper]

https://stackoverflow.com/questions/66461873/use-dataframe-name-as-suffix-when-joining-several-data-frames/66463627#66463627

[moodymudskipper]

Maybe better to have a new arg for auxiliary col names , it will be a function or formula taking the original name of the col and the name of the df as an inputs.

The name is taken using NSE from x or y arg, OR from named lists.

So we can do for instance :

power_left_join(df1, df2, by = whatever, aux = ~ paste0(.x, "_", substr(.y, 1, 3))
power_left_join(lst(df1, df2, df3), by = whatever, aux = ~ paste0(.x, "_", substr(.y, 1, 3))

[moodymudskipper]

A preprocessor rename_all_aux() could work too, would allow renaming only one side.

[moodymudskipper]

https://stackoverflow.com/questions/65816477/nested-full-join-with-suffixes-for-more-than-2-data-frames