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) > 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.





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