Skip to main content

Minimum Transformation

Minimum transformation is used to return the smallest value in the given source columns. You have to choose at least two source columns to apply this transformation.

Steps to Apply Minimum Transformation​

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

Step 1: Add Transformation Type​

First, visit the Add Transformation page to add the Minimum transformation.

Step 2: Select Source Columns​

In the Source Columns box specify at least two columns to get the smallest of the given expressions.

Select

Step 3: Select Target Column​

  • Now enter the Target Column name to store your transformed data

  • Click on the Create New Column to populate the transformed data into the new column

Create

Use Advanced Option​

  • To use advanced options. First, click the Advanced Options down arrow
Advanced
  • Click the Target Column Type dropdown to specify the data type of the target column
  • If your target 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)
Type

Note

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

Step 4: Save the Transformation 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 5: Save & Test Transformation​

Once the above-mentioned steps are done, click the Save & Test button to test and 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