joinXL (version 1.0.1)

innerjoinXL: Performs a SQL type inner join on 2 Excel files

Description

Merges all rows from base file and 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

innerjoinXL()

Value

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

See Also

fulljoinXL for SQL type full join, leftjoinXL for SQL type left join, rightjoinXL for SQL type right join, minusXL for file1 minus file2

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

Examples

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