td.join: Join Tables in Teradata

In nonsleepr/teradataR: Teradata R Package

Description

Join tables in Teradata based on their td data frames and index values.

Usage

td.join(tdf1, tdf2, oTable = "newJoinTable", oDatabase = "", index1 = "", index2 = "", joinType = "inner")

Arguments

tdf1	first td data frame of table one.
tdf2	second td data fame of table two.
oTable	output table name of result.
oDatabase	output database name of result.
index1	index columns to use for the join from table one.
index2	index columns to use for the join from table two.
joinType	join type. One of ("inner", "left outer", "right outer", "full outer").

Details

Allow joining of columns from two Teradata tables. The columns in the td data frames are used as the new column names along with the index from the first table. If indices are missing the primary indices will be searched and used.

Value

td data frame pointing to the new output table from the join.

Examples

## Not run: 
td.join(tdf, tdf2, "myNewTable",index1=c("pidx1","pidx2"), index2=c("pidx1","pidx2"))

## End(Not run)

nonsleepr/teradataR documentation built on May 23, 2019, 9:32 p.m.