joinXL (version 1.0.1)

fulljoinXL: 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.

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)