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,
data.sequence.column = NULL,
data.order.column = NULL
)
Arguments
data |
Required Argument. |
data.order.column |
Optional Argument. |
input.columns |
Optional Argument. |
output.column |
Required Argument. |
delimiter |
Optional Argument. |
include.column.name |
Optional Argument. |
data.sequence.column |
Optional Argument. |
Value
Function returns an object of class "td_pack_mle" which is a named
list containing object of class "tbl_teradata".
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("pack_example", "ville_temperature")
# Create object(s) of class "tbl_teradata".
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
)