Home
Turium Algoreus
Turium Algoreus
  • Turium Algoreus Documentation
    • Turium Algoreus Overview
      • How to Guides
        • Axons (Pipeline) User Guide
          • Algoreus Genesis
          • Algoreus Node
          • Steps for a simple batch Axon in Algoreus
          • Configuring Axon in Algoreus
          • Deploying an Axon in Algoreus
          • Running an Axon in Algoreus
          • Viewing and downloading logs in the Genesis in Algoreus
          • Scheduling an Axon in Algoreus
          • Reusable Axons in Algoreus
          • Using Triggers in Algoreus
          • Working with multiple versions of the same node in Algoreus
          • Modifying a draft Axon in Algoreus
          • Editing a deployed Axon in Algoreus
          • Duplicating An Axon in Algoreus
          • Deleting an Axon in Algoreus
          • Deploying nodes from the Algoreus Hub
          • Using node templates in Algoreus
          • Exporting and importing Axons in Algoreus
          • Dynamic resource configuration in Algoreus
          • Working with namespaces in Algoreus
        • Soma (Transformation) User Guide
          • Algoreus Soma Overview
          • Algoreus Soma Concepts
          • Algoreus Soma UI components
          • Working with multiple datasets
          • Navigating between Soma and Algoreus Genesis
          • Editing a transformation created in the Soma
          • Soma data types
          • Working with connections in Soma
          • Parsing a CSV file
          • Strings Formatting
          • Sending records to error
          • Working with numbers in Soma
          • Working with Decimal types in Soma
          • Performing date transformations in Soma
          • Filtering records
          • Finding and replacing values in a column
          • Filling null or empty cells
          • Copying, deleting, and keeping columns
          • Renaming a column
          • Joining two columns
          • Swapping two column names
          • Extracting fields to retrieve values
          • Exploding fields
          • Masking data
          • Encoding records to store or transfer data
          • Decoding records to store or transfer data
          • Applying a Hashing algorithm to a column
          • Upgrading the Soma transformation node version
          • Viewing and downloading a schema in Soma
          • Viewing Soma Service logs
        • Cerebellum (Operations and Monitoring) User Guide
          • Logging and Monitoring
          • Metrics
          • Dashboard and Reports
          • Preferences and Runtime Arguments
          • Transaction Service Maintenance
        • Engram (Metadata) User Guide
          • System Metadata
          • Discovery and Lineage
          • Audit Logging
          • Metadata Management
          • Accessing Metadata Programmatically
          • Metadata Field-Level Lineage
        • Clone (Replication) User Guide
          • Cloning overview
          • Clone Concepts
          • Adding Transformations to a Cloning Job
          • Deleting a Cloning Job
          • Tutorial: Cloning data from Oracle Database to BigQuery
        • Algology (Visualisation) User Guide
          • Dashboards
            • Using Dashboards
            • Building Dashboards
            • Manage dashboards
            • Publishing Dashboard
            • Playlist
            • Create and manage reports
            • Share dashboards and panels
            • Access Dashboard Usage
            • Search Dashboards
          • Panel Editor
            • Configure Panel Options
            • Configure standard options
          • Visualisations
            • Alert List
            • Bar Chart
            • Bar Gauge
            • Candlestick Panel
            • Canvas
            • Dashboard List
            • Flame Graph
            • Gauge
            • Heatmap
            • Histogram
            • Logs
            • Node Graph
            • Traces Panel
            • Pie Chart
            • State Timeline
            • Stat Panel
            • Time series
            • Trend Panel
            • Text Panel
            • Table
            • GeoMap
            • Datagrid Panel
            • Status history
            • Annotations
          • Explore
            • Logs in Explore
            • Queries in Explore
            • Tracing in Explore
            • Inspector in Explore
    • Turium Algoreus Connectors
Powered by GitBook
On this page
  • Performing numeric calculations on values in one column
  • Performing numeric calculations on values in two columns
  • Performing numeric calculations on values in three or more columns

Was this helpful?

  1. Turium Algoreus Documentation
  2. Turium Algoreus Overview
  3. How to Guides
  4. Soma (Transformation) User Guide

Working with numbers in Soma

  • Performing numeric calculations on values in one column

  • Performing numeric calculations on values in two columns

  • Performing numeric calculations on values in three or more columns

In Algoreus, you can quickly perform numeric calculations on the following types of columns:

  • Integer

  • Decimal

  • Double

  • Float

  • Long

  • Short

Note: To use numeric functions on Decimal columns, use the Algoreus CLI.

You can use numeric functions on one or multiple columns. The available numeric functions vary depending on how many columns you select. You can choose to create a new column with the results of the calculations or you can have the results appear in the column where you add the transformation.

If you apply a numeric function to a single column, the behavior is different than if you apply a numeric function to multiple columns.

For example, if you use the Multiply function on a single column, you must specify a decimal value by which to multiply each value in the column. Algoreus performs the multiplication on the sample data and displays the new values in the same column or in a new column.

If you use the Multiply function on multiple columns, Algoreus multiplies the values in each row for the selected columns and displays the new values in the first column of the transformation.


Performing numeric calculations on values in one column

You can perform the following calculations on all values in the column:

  • Add

  • Subtract

  • Multiply

  • Divide

  • Module

  • Power of

  • Square

  • Square root

  • Cube

  • Cube root

  • Log

  • Natural log

  • Absolute value

  • Ceil

  • Floor

  • Cos

  • Sin

  • Tan

  • Arccos

  • Arcsin

  • Arctan

  • Round

  • Random

To apply a numeric calculation to one column, follow these steps:

  1. Click the drop-down button next to the column name.

  2. Click Calculate, and then select the numeric function you want to perform.

  3. Some functions require a decimal value to complete the calculation. For example, if you select Subtract, enter the number to subtract from each row.

  4. You can choose to create a new column with the results of numeric calculation or overwrite the values in the current column.

  5. Click Apply.

The values change based on the calculation. Algoreus adds the corresponding function as a step in the recipe.

When you run the data axon, the transformation is applied to all values in the column.


Performing numeric calculations on values in two columns

You can perform the following numeric calculations on values in each row in two columns:

  • Add

  • Subtract

  • Multiply

  • Divide

  • Module

  • LCM

  • Equal

  • Max

  • Min

  • Average

To apply a numeric calculation to two columns, follow these steps:

  1. To select the columns, click the box to the right of the column names.

  2. Click the drop-down button next to one of the column names and click Calculate.

  3. Select the numeric function you want to perform.

  4. You can choose to create a new column with the results of numeric calculations or overwrite the values in the current column.

  5. Click Apply.

The values change based on the calculation. Algoreus adds the corresponding function as a step in the recipe.


Performing numeric calculations on values in three or more columns

You can perform the following calculations on values in each row in three or more columns:

  • Add

  • Multiply

  • Max

  • Min

  • Equal

  • Average

To apply a numeric calculation to three or more columns, follow these steps:

  1. To select the columns, click the box to the right of the column name.

  2. Click the drop-down button next to one of the column names and click Calculate.

  3. Select the numeric function you want to perform.

  4. You can choose to create a new column with the results of numeric calculations or overwrite the values in the current column.

  5. Click Apply.

The values change based on the calculation. Algoreus adds the corresponding function as a step in the recipe.


PreviousSending records to errorNextWorking with Decimal types in Soma

Last updated 1 year ago

Was this helpful?