Description Usage Value Author(s) See Also Examples
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"
1 | minusXL()
|
In working directory: source_minus_target.xlsx, target_minus_source.xlsx, rowsNOTduplicated.xlsx
Yvonne Glanville, yvonneglanville@gmail.com
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
1 2 3 4 | ## Not run:
minusXL();
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.