joinXL: Perform Joins or Minus Queries on 'Excel' Files

Performs Joins and Minus Queries on 'Excel' Files fulljoinXL() Merges all rows of 2 'Excel' files based upon a common column in the files. innerjoinXL() Merges all rows from base file and join file when the join condition is met. leftjoinXL() Merges all rows from the base file, and all rows from the join file if the join condition is met. rightjoinXL() Merges all rows from the join file, and all rows from the base file if the join condition is met. minusXL() Performs 2 operations source-minus-target and target-minus-source If the files are identical all output files will be empty. Choose two 'Excel' files via a dialog box, and then follow prompts at the console to choose a base or source file and columns to merge or minus on.

Install the latest version of this package by entering the following in R:
install.packages("joinXL")
AuthorYvonne Glanville [aut, cre]
Date of publication2016-09-19 01:45:37
MaintainerYvonne Glanville <yvonneglanville@gmail.com>
LicenseGPL-3
Version1.0.1
http://github.com/yvonneglanville/joinXL

View on CRAN

Files

inst
inst/doc
inst/doc/Functionality.Rmd
inst/doc/Functionality.html
NAMESPACE
NEWS.md
R
R/minusXL.R R/innerjoinXL.R R/rightjoinXL.R R/fulljoinXL.R R/leftjoinXL.R
vignettes
vignettes/Functionality.Rmd
README.md
MD5
build
build/vignette.rds
DESCRIPTION
man
man/innerjoinXL.Rd man/leftjoinXL.Rd man/minusXL.Rd man/fulljoinXL.Rd man/rightjoinXL.Rd

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.