Data Mapping 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

Example 1:

Step 1: Create an empty dm_to_type_example_1 using AIOps studio as shown in the below screenshot

Empty pipeline

##### This pipeline creates a set of records/dateset details with different datatypes ##### String and integer. ###### This pipeline uses dm to_type to convert basic string data type to int datatype --> @dm:empty --> @dm:addrow id = 'a1' & x = '10.0' & y = '3.11' & z = 9 --> @dm:addrow id = 'a2' & x = '1.0' & y = '13.0' & z = 4 --> @dm:addrow id = 'a3' & x = '7.0' & y = '3.0' & z = 3 --> @dm:addrow id = 'a4' & x = '4.0' & y = '-1.4' & z = 9 --> @dm:to_type columns ='x,y' & type = 'int'

Pipeline code added to above created empty pipeline

Step 3: Click verify button to verify the pipeline. RDA will verify the pipeline without any errors (as shown below)

Pipeline code verified

Step 4: Click execute button to execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

Pipeline execution without any errors

Step 5: Verify that the output data is enriched with the requested column names and print the output as shown in the below screenshot.

As shown in the above pipeline, this function is used to convert string to int (or float) datatype needed for any integer manipulation, etc.