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

Description

The Pack function packs data from multiple input columns into a single column. The packed column has a virtual column for each input column. By default, virtual columns are separated by commas and each virtual column value is labeled with its column name.

Usage

  td_pack_mle (
    data = NULL,
    input.columns = NULL,
    output.column = NULL,
    delimiter = ",",
    include.column.name = TRUE
  )

Arguments

Value

Function returns a named list containing Teradata tbl object. Named list members 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("pack_example", "ville_temperature")
    
    # Create remote tibble objects.
    ville_temperature <- tbl(con, "ville_temperature")
    
    # Example 1 -
    td_pack_out1 <- td_pack_mle(data = ville_temperature,
                      input.columns = c("city", "state", "period", "temp_f"),
                      output.column = "packed_data",
                      delimiter = ",",
                      include.column.name = TRUE
                      )
    
    # Example 2 -
    td_pack_out2 <- td_pack_mle(data = ville_temperature,
                      input.columns = c("city", "state", "period", "temp_f"),
                      output.column = "packed_data",
                      delimiter = "|",
                      include.column.name = FALSE
                      )