Ensure Columns
Returns a copy of a specified table, modified where necessary to guarantee that given columns have specified types.
Arguments
The function has the following arguments:
Table: The specified table.
Column Name(s): Text string that specifies the columns to be modified if necessary. Supply a single column name or a semicolon-separated list of column names.
Column Type(s): Text string that specifies the types. Supply a single name or a semicolon-separated list of names. The
nth element of
Column Type(s) is the type to be guaranteed for the column specified by the
nth element of
Column Name(s).
Values: Semicolon-separated list of values to substitute when a value must be modified. The
nth element of
Values is used for the column named by the
nth element of
Column Name(s).
This function returns a table.