Integer Transform

Data in Integer type can be converted to Date, Decimal, Float, Hex string, String, Time or Timestamp type. You can also perform the following operations:

Add

This operation adds a specified integer value to the integer.

InputValueOutput
50151
213

Average merge

This operation calculates the values from the integer 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 integer 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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Float type:

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

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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output (Group Field: Field 1), which is in Float type:

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

Divide

This operation divides the integer by a specified integer value.

InputValueOutput
50225
221

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
11010
111011

Max merge

This operation merges the values from the integer 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 integer field, this operation directly returns the maximum.

The following table shows an example of the input:

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

The following table shows an example of the output, which is in Integer type:

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

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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output (Group Field: Field 1), which is in Integer type:

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

Median merge

This operation merges the values from the integer 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 integer 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 integer field, it returns the average directly.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105
ABC108
ABC109
DEF01
DEF02

The following table shows an example of the output, which is in Float type:

Field 1Field 2Field 3Field 4Field 5
ABC108.0
DEF01.5

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
ABC108
ABC109
DEF01
DEF02

The following table shows an example of the output, which is in Float type:

Field 1Field 2Field 3Field 4Field 5
ABC108.0
ABC108.0
ABC108.0
DEF01.5
DEF01.5

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
1011
010

Min merge

This operation merges the values from the integer 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 integer field, this operation directly returns the minimum.

The following table shows an example of the input:

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

The following table shows an example of the output, which is in Integer type:

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

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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Integer type:

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

Multiply

This operation multiplies a specified integer value with the integer.

InputValueOutput
502100
224

Percent

This operation calculates the percentage of values in the corresponding rows from the integer 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. The output is in Float type.

Field 1Field 2Output (Group Field: Field 1)
A20.2222*
A30.3333*
A40.4444*
B41.0
C41.0

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

Product merge

This operation calculates the values from the integer 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 integer 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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Integer type:

Field 1Field 2Field 3Field 4Field 5
ABC10315
DEF03

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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Integer type:

Field 1Field 2Field 3Field 4Field 5
ABC10315
ABC10315
ABC10315
DEF03
DEF03

Remainder

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

Field 1ValueOutput
5032
232

Standard deviation merge

This operation calculates the values from the integer 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 integer 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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Float type:

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

*This is an approximate value of the output for the purpose 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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Float type:

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 integer value from the integer.

InputValueOutput
50149
211

Sum merge

This operation calculates the values from the integer 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 integer 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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output:

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

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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output:

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

Variance merge

This operation calculates the values from the integer 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 integer 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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output, which is in Float type:

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

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
ABC107
ABC109
DEF01
DEF03

The following table shows an example of the output (Group Field: Field 1), which is in Float type:

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