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. |
data.order.column |
Optional Argument. |
exclude |
|
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") )