5.5.6.6. Updating columns

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.5. Standard > 5.5.6. Calculator (High-Speed action) >

5.5.6.6. Updating columns

 

By default, each tab of the clip0163Calculator Action is defining a new column inside the output table of the Action. You can also use a tab to UPDATE an existing column (instead of creating a new one): The following example updates the column “Churn”:
 

a)It replaces all the NULL values with the number “0” (using the “nvl()” function).
 

b)It changes the Meta-Type of the “Churn” column to the Float Meta-Type.

 

ANATEL~3_img470

 

 

Note that we could have also used the ChangeDataType clip0187  Action with the following parameters (and this second technique is faster):

 

clip0186