td.merge: Merge Rows of Teradata Tables

Description Usage Arguments Details Value Examples

View source: R/td.merge.R

Description

Function to merge rows of two Teradata tables based on merge type.

Usage

1
td.merge(tdf1, tdf2, oTable = "newMergeTable", oDatabase = "", mergeType = "union")

Arguments

tdf1

td data frame of table one.

tdf2

td data frame of table two.

oTable

output table name.

oDatabase

output database name.

mergeType

type of merge to perform. Values can be ("union","minus",and "intersect")

Details

Create a new output table based on the merge type between two td data frames. Each td data frame must consist of the same number of columns in order to merge correctly.

Value

td data frame pointing to the output table in Teradata.

Examples

1
2
3
4
## Not run: 
td.merge(tdf1, tdf2, "newTable")

## End(Not run)

nonsleepr/teradataR documentation built on May 23, 2017, 4:47 p.m.