Teradata R Package Function Reference - Antiselect - Teradata R Package - Look here for syntax, methods and examples for the functions included in the Teradata R Package.

Description

Antiselect (td_antiselect_mle) returns all columns except those specified in the "exclude" argument.

Usage

  td_antiselect_mle (
      data = NULL,
      exclude = NULL,
      data.sequence.column = NULL
  )

Arguments

Value

Function returns an object of class "td_antiselect_mle" 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 - Exclude five columns as specified in the "exclude" argument
    td_antiselect_out <- td_antiselect_mle(data = antiselect_input,
                                       exclude = c("rowids","orderdate","discount",
                                                  "province", "custsegment")
                                       )