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

Share:

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.

Author
Yvonne Glanville [aut, cre]
Date of publication
2016-09-19 01:45:37
Maintainer
Yvonne Glanville <yvonneglanville@gmail.com>
License
GPL-3
Version
1.0.1
URLs

View on CRAN

Man pages

fulljoinXL
Performs a SQL type full join on 2 Excel files
innerjoinXL
Performs a SQL type inner join on 2 Excel files
leftjoinXL
Performs a SQL type left join on 2 Excel files
minusXL
Performs a SQL type minus query on 2 Excel files
rightjoinXL
Performs a SQL type right join on 2 Excel files

Files in this package

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