rightjoinXL {joinXL}

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, [e-mail]

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)