cfxdm - dm:to_type

Set data type on columns

dm:to_type: It allows to change or set the data type to string or integer (numeric) or float for specified columns.

@param 'columns' (mandatory, comma separated list of column names), @param 'type' (mandatory, supported options are: str / int / float)

dm:to_type: Syntax

  • columns (mandatory): Comma separated list of column names

  • type (mandatory): Supported options are: str (string or text) / int (integer or numeric) / float

In the below example, it sets the columns vm_cpu_count and vm_memory data type as 'Integer (Numeric)'

dm:recall tag is used to retrieve the data from 'vm-inventory' dataset and piped into dm:to_type tag to change the data type.

tag @dm:recall
data name = 'vm-inventory' --> dm:to_type columns ='vm_cpu_count,vm_memory' & type = 'int'

In the below example, it sets the column vm_cpu_usage_perc data type as 'Float'

data name = 'vm-inventory-metric' --> dm:to_type columns ='vm_cpu_usage_perc' & type = 'float'

Last updated