minusXL: Performs a SQL type minus query on 2 Excel files

In joinXL: Perform Joins or Minus Queries on '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, [e-mail]

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)

joinXL documentation built on May 1, 2019, 11:27 p.m.