Teradata R Package Function Reference - 16.20 - Antiselect - Teradata R Package

Teradata® R Package Function Reference

prodname
Teradata R Package
vrm_release
16.20
created_date
February 2020
category
Programming Reference
featnum
B700-4007-098K

Description

Antiselect function returns all columns except those specified in the 'exclude' argument.
Note: This function is only available when tdplyr is connected to Vantage 1.1 or later versions.

Usage

  td_antiselect_sqle (
    data = NULL,
    exclude = NULL,
    data.order.column = NULL
  )

Arguments

data

Required Argument.
Specifies the input tbl_teradata.

data.order.column

Optional Argument.
Specifies Order By columns for data.
Values to this argument can be provided as vector, if multiple columns are used for ordering.
Types: character OR vector of Strings (character)

exclude


Required Argument.
Specifies the names of the columns not to return.
Types: character OR vector of Strings (character)

Value

Function returns an object of class "td_antiselect_sqle" which is a named list containing Teradata tbl object.
Named list member can be referenced directly with the "$" operator using name: result.

Examples

    # Get the current context/connection
    con <- td_get_context()$connection
    
    # Load example data.
    loadExampleData("antiselect_example", "antiselect_input")
    
    # Create remote tibble objects.
    antiselect_input <- tbl(con, "antiselect_input")
    
    # Example 1 - Exclude five columns as specified in the "exclude" argument
    td_antiselect_sqle_out <- td_antiselect_sqle(data = antiselect_input,
                                                 exclude = c("rowids","orderdate","discount", "province",
                                                             "custsegment")
                                                )