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.
1
tag @dm:recall
Copied!
1
data name = 'vm-inventory' --> dm:to_type columns ='vm_cpu_count,vm_memory' & type = 'int'
Copied!
In the below example, it sets the column vm_cpu_usage_perc data type as 'Float'
1
data name = 'vm-inventory-metric' --> dm:to_type columns ='vm_cpu_usage_perc' & type = 'float'
Copied!
Last modified 6mo ago
Copy link