fulljoinXL: Performs a SQL type full join on 2 Excel files

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

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)

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