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

Description Usage Value Author(s) See Also Examples

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

1

Value

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

Author(s)

Yvonne Glanville, yvonneglanville@gmail.com

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

1
2
3
4
## Not run: 
leftjoinXL();

## End(Not run)


Search within the joinXL package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.