Skip to main content

Round Transformation

Rounding means adjusting the digits ( up or down) to make the calculation easier. This transformation type will make the number simpler and keep the value close to its original value.

Steps to Apply Rounding Transformation​

This guide will give you a brief idea of what steps you need to follow to apply the Round Transformation in a queried data.

Step 1: Add Transformation Type​

First, visit the "Add Transformation" page to add the Rounding transformation.

Step 2: Select Source Column​

Now select the source column dropdown to select the values you want to make simpler, shorter and keep it close to the original values.

Select

Use Advanced Options​

  • When you click on the Advanced options down arrow you will get the choice to save the desired output in the same source column or want to create a new column
Advanced
  • By default, your output will get saved in the same column, click on the Create a new column to create a new column name to save the output
Create
  • If your source column data type is decimal and you want an exact numeric, you can specify the scale (Scale can be positive or negative) and precision (the total number of digits, both to the left and the right of the decimal point)

If the scale is not specified, the default scale is 4. If the precision is not specified, the default precision is 20.

Step 3: Save the Configuration​

Click the Save button to save the Transformation configuration.

Add Another Transformation​

After defining the first Transformation, you can add multiple transformations to the defined Transformation or add another new Transformation step to a bot This flexibility helps you to get the desired output in one go.

Step 4: Save & Test Transformation​

Once the above-mentioned steps are done click the Save & Test button to save the transformation.

Save & Test

Any Question? 🤓​

We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io