Change Data Types

Change the data type of 1 or many columns

Function:

Data_Types(table = string, dtype_group = {col =string, dtype = string, col = string, dtype = string, col = string, ...})

 

Parameters:

Table: Table name on which to perform function

dtype_group: Groups all of the columns and data type to change

col: Column to change data type. There can be many of these. List out individually with the data type.

dtype: Data type to change the column listed before to. There can be many of these. List out individually with the data type.

 

 

Examples:

Data_Types(table = Budget, dtype_group = {col = "Jan", dtype = "Integer", col = "Feb", dtype = "Integer", col = "Date", dtype = "Date"})