Float Transform

Data in Float type can be converted to Decimal, Integer or String type. You can perform the following operations:

Add

This operation adds a specified value to the float value.

InputValueOutput
50.62491.151.7249
0.7211.11.821

Average merge

This operation calculates the values from the float field into the average and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly calculates the values into the average.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC107.1
DEF02.2

Average retain

This operation is similar to the Average merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC107.1
ABC107.1
ABC107.1
DEF02.2
DEF02.2

Divide

This operation divides the float value by a specified value.

InputValueOutput
50.6249225.31245
0.72120.3605

Max

This operation changes each value in the selected field to a specified maximum value. If the original value is less than the specified maximum, the result becomes the maximum, otherwise it is unchanged.

InputMaximumOutput
1.105110.105110.1051
11.234510.105111.2345

Max merge

This operation merges the values from the float field into the maximum and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly returns the maximum.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC109.1
DEF03.2

Max retain

This operation is similar to the Max merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC109.1
ABC109.1
ABC109.1
DEF03.2
DEF03.2

Median merge

This operation merges the values from the float field into a median value and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly returns the median. In most cases, the output should be an existing value most close to the average. If there are only two values in the float field, it returns the average directly.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.78
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC107.78
DEF02.2

Median retain

This operation is similar to the Median merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.78
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC107.78
ABC107.78
ABC107.78
DEF02.2
DEF02.2

Min

This operation changes each value in the selected field to a specified minimum value. If the original value is greater than the specified minimum, the result becomes the minimum, otherwise it is unchanged.

InputMaximumOutput
10.10511.10511.1051
0.23451.10510.2345

Min merge

This operation merges the values from the float field into the minimum and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly returns the minimum.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
DEF01.2

Min retain

This operation is similar to the Min merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC105.1
ABC105.1
DEF01.2
DEF01.2

Multiply

This operation multiplies a specified value with the float value.

InputValueOutput
50.62492101.2498
0.72121.442

Percent

This operation calculates the percentage of values in the corresponding rows from the float field, when the corresponding rows from the Group Field include exactly the same information. Otherwise, it returns 1, which means 100 percent. The summary of the output from the corresponding rows equals to 1.

Field 1Field 2Output (Group Field: Field 1)
A2.00010.20001*
A3.00010.30001
A4.99980.49998
B4.00011.0
C4.99981.0

*This is an approximate value of the output for the convenience of illustration.

Product merge

This operation calculates the values from the float field into the product value and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly calculates the values into the product.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC10329.511
DEF03.84

Product retain

This operation is similar to the Product merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC10329.511
ABC10329.511
ABC10329.511
DEF03.84
DEF03.84

Remainder

This operation returns the remainder when the values in the float field are divided by a specified value.

Field 1ValueOutput
3.000121.0001
4.999820.9998

Round down

This operation calculates the round-down value of the float value.

InputOutput
50.999950
2.1632

Round half down

This operation calculates the round-half-down value of the float value.

InputOutput
50.999951
2.1632

Round half even

This operation calculates the round-half-even value of the float value.

InputOutput
50.999951
2.1632

Round half up

This operation calculates the round-half-up value of the float value.

InputOutput
50.999951
2.1632

Round up

This operation calculates the round-up value of the float value.

InputOutput
50.999951
2.1633

Standard deviation merge

This operation calculates the values from the float field into the standard deviation value and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly calculates the values into the standard deviation.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC102.0
DEF01.4142*

*This is an approximate value of the output for the purposes of illustration.

Standard deviation retain

This operation is similar to the Standard deviation merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC102.0
ABC102.0
ABC102.0
DEF01.4142*
DEF01.4142*

*This is an approximate value of the output for the purpose of illustration.

Subtract

This operation subtracts a specified value from the float value.

InputValueOutput
50.62491.149.5249
10.5371.19.437

Sum merge

This operation calculates the values from the float field into the summary and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly calculates the values into the summary.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC1021.3
DEF04.4

Sum retain

This operation is similar to the Sum merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC1021.3
ABC1021.3
ABC1021.3
DEF04.4
DEF04.4

To ceiling

This operation calculates the ceiling value of the float value.

InputOutput
50.999951.0
2.1633.0

To floor

This operation calculates the floor value of the float value.

InputOutput
50.999950.0
2.1632.0

Variance merge

This operation calculates the values from the float field into the variance and keeps the other fields unchanged, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge. If there is only one float field, this operation directly calculates the values into the variance.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output:

Field 1Field 2Field 3Field 4Field 5
ABC104.0
DEF02.0*

*This is an approximate value of the output for the purpose of illustration.

Variance retain

This operation is similar to the Variance merge operation. The differences are in the following:

  • It allows you to select a Group Field.

  • It retains the number of rows, instead of merging the corresponding rows into one.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Group Field: Field 1):

Field 1Field 2Field 3Field 4Field 5
ABC104.0
ABC104.0
ABC104.0
DEF02.0*
DEF02.0*

*This is an approximate value of the output for the purpose of illustration.