Description Usage Value Author(s) See Also Examples
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.
1 |
The joined file, right_join.xlsx is placed in the working directory.
Yvonne Glanville, yvonneglanville@gmail.com
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
1 2 3 4 | ## Not run:
rightjoinXL();
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.