| Title: | Perform Joins or Minus Queries on 'Excel' Files |
| Version: | 1.0.1 |
| Description: | 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. |
| Depends: | R (≥ 3.3.1) |
| Imports: | readxl (≥ 0.1.1), openxlsx (≥ 3.0.0), timeSeries (≥ 3022.101.2), data.table (≥ 1.9.6), rChoiceDialogs(≥ 1.0.6), R.utils(≥ 2.3.0), rJava (≥ 0.9-8), graphics (≥ 3.3.1), Rcpp (≥ 0.11.1), grDevices (≥ 3.3.1), stats (≥ 3.3.1), timeDate (≥ 2150.95) |
| VignetteBuilder: | knitr |
| License: | GPL-3 |
| Encoding: | UTF-8 |
| LazyData: | true |
| URL: | http://github.com/yvonneglanville/joinXL |
| BugReports: | http://github.com/yvonneglanville/joinXL/issues |
| RoxygenNote: | 5.0.1 |
| Suggests: | knitr, rmarkdown |
| NeedsCompilation: | no |
| Packaged: | 2016-09-12 00:01:37 UTC; yvonn |
| Author: | Yvonne Glanville [aut, cre] |
| Maintainer: | Yvonne Glanville <yvonneglanville@gmail.com> |
| Repository: | CRAN |
| Date/Publication: | 2016-09-19 01:45:37 |
Performs a SQL type full join on 2 Excel files
Description
Merges all rows of 2 Excel files based upon a common column in each file. Choose 2 files via dialog box. Prompted at the console to make 1 file a base file. Prompted to choose a column from each Excel file to use as the join condition.
Usage
fulljoinXL()
Value
The joined file, full_join.xlsx is placed in the working directory.
Author(s)
Yvonne Glanville, yvonneglanville@gmail.com
See Also
innerjoinXL for SQL type inner join, leftjoinXL for SQL type left join,
rightjoinXL for SQL type right join, minusXL for file1 minus file2
Other X.joinXL.: innerjoinXL,
leftjoinXL, minusXL,
rightjoinXL
Examples
## Not run:
fulljoinXL();
## End(Not run)
Performs a SQL type inner join on 2 Excel files
Description
Merges all rows from base file and join file if the join condition is met. Choose 2 files via dialog box. Prompted at the console to make 1 file a base file. Prompted to choose a column from each Excel file to use as the join condition.
Usage
innerjoinXL()
Value
The joined file, inner_join.xlsx is placed in the working directory.
Author(s)
Yvonne Glanville, yvonneglanville@gmail.com
See Also
fulljoinXL for SQL type full join, leftjoinXL for SQL type left join,
rightjoinXL for SQL type right join, minusXL for file1 minus file2
Other X.joinXL.: fulljoinXL,
leftjoinXL, minusXL,
rightjoinXL
Examples
## Not run:
innerjoinXL();
## End(Not run)
Performs a SQL type left join on 2 Excel files
Description
Selects all rows from the base file, and all rows from the join file if the join condition is met. Choose 2 files via dialog box. Prompted at the console to make 1 file a base file. Prompted to choose a column from each Excel file to use as the join condition.
Usage
leftjoinXL()
Value
The joined file, left_join.xlsx is placed in the working directory.
Author(s)
Yvonne Glanville, yvonneglanville@gmail.com
See Also
innerjoinXL for SQL type inner join, fulljoinXL for SQL type full join,
rightjoinXL for SQL type right join, minusXL for file1 minus file2
Other X.joinXL.: fulljoinXL,
innerjoinXL, minusXL,
rightjoinXL
Examples
## Not run:
leftjoinXL();
## End(Not run)
Performs a SQL type minus query on 2 Excel files
Description
Performs 2 operations: source-minus-target and target-minus-source If the files are identical all outputs are empty. Choose 2 files via dialog box, and then from the console choose the common column between the files. 3 separate .xlsx files are returned to the user "source_minus_target.xlsx" "target_minus_source.xlsx" "rowsNOTduplicated.xlsx"
Usage
minusXL()
Value
In working directory: source_minus_target.xlsx, target_minus_source.xlsx, rowsNOTduplicated.xlsx
Author(s)
Yvonne Glanville, yvonneglanville@gmail.com
See Also
innerjoinXL for SQL type inner join, leftjoinXL for SQL type left join,
rightjoinXL for SQL type right join, fulljoinXL for SQL type full join
Other X.joinXL.: fulljoinXL,
innerjoinXL, leftjoinXL,
rightjoinXL
Examples
## Not run:
minusXL();
## End(Not run)
Performs a SQL type right join on 2 Excel files
Description
Selects all rows from the join file, and all rows from the base file if the join condition is met. Choose 2 files via dialog box. Prompted at the console to make 1 file a base file. Prompted to choose a column from each Excel file to use as the join condition.
Usage
rightjoinXL()
Value
The joined file, right_join.xlsx is placed in the working directory.
Author(s)
Yvonne Glanville, yvonneglanville@gmail.com
See Also
innerjoinXL for SQL type inner join, leftjoinXL for SQL
type left join, fulljoinXL for SQL type full join, minusXL for
file1 minus file2
Other X.joinXL.: fulljoinXL,
innerjoinXL, leftjoinXL,
minusXL
Examples
## Not run:
rightjoinXL();
## End(Not run)