joinXL (version 1.0.1)

leftjoinXL: Performs a SQL type left join on 2 Excel files

Description

Selects all rows from the base file, and all rows from the join 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

leftjoinXL()

Value

The joined file, left_join.xlsx is placed in the working directory.

See Also

innerjoinXL for SQL type inner join, fulljoinXL for SQL type full join, rightjoinXL for SQL type right join, minusXL for file1 minus file2

Other X.joinXL.: fulljoinXL, innerjoinXL, minusXL, rightjoinXL

Examples

## Not run: 
# leftjoinXL();
# ## End(Not run)