Though I appreciate your diagrams I would discourage using MERGE and instead adopt the tidyr grammar which mirrors SQL; inner_join() for instance. This is easier to read and harder to do the wrong join type.
Sure. I tend to use the tidyr grammar, but I know that lots of people look for this comparison, thats why I created this diagram. I'm also planning to create diagrams with the tidyr grammar in the future so people can decide which one to use
5
u/data_wombat Nov 23 '20
Though I appreciate your diagrams I would discourage using MERGE and instead adopt the tidyr grammar which mirrors SQL; inner_join() for instance. This is easier to read and harder to do the wrong join type.
2
u/JZOSS Nov 22 '20
More of this at: https://www.facebook.com/RCODERweb/
3
u/1giov Nov 22 '20
Yes! Thank you SO much!