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:
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 7.0 |
| D | E | F | 0 | 2.0 |
This operation is similar to the Average merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output (Group Field: Field 1), which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 7.0 |
| A | B | C | 10 | 7.0 |
| A | B | C | 10 | 7.0 |
| D | E | F | 0 | 2.0 |
| D | E | F | 0 | 2.0 |
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.
| Input | Maximum | Output |
|---|---|---|
| 1 | 10 | 10 |
| 11 | 10 | 11 |
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Integer type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 9 |
| D | E | F | 0 | 3 |
This operation is similar to the Max merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output (Group Field: Field 1), which is in Integer type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 9 |
| A | B | C | 10 | 9 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 3 |
| D | E | F | 0 | 3 |
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 8 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 2 |
The following table shows an example of the output, which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 8.0 |
| D | E | F | 0 | 1.5 |
This operation is similar to the Median merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 8 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 2 |
The following table shows an example of the output, which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 8.0 |
| A | B | C | 10 | 8.0 |
| A | B | C | 10 | 8.0 |
| D | E | F | 0 | 1.5 |
| D | E | F | 0 | 1.5 |
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.
| Input | Maximum | Output |
|---|---|---|
| 10 | 1 | 1 |
| 0 | 1 | 0 |
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Integer type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| D | E | F | 0 | 1 |
This operation is similar to the Min merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Integer type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 5 |
| A | B | C | 10 | 5 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 1 |
This operation multiplies a specified integer value with the integer.
| Input | Value | Output |
|---|---|---|
| 50 | 2 | 100 |
| 2 | 2 | 4 |
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 1 | Field 2 | Output (Group Field: Field 1) |
|---|---|---|
| A | 2 | 0.2222* |
| A | 3 | 0.3333* |
| A | 4 | 0.4444* |
| B | 4 | 1.0 |
| C | 4 | 1.0 |
*This is an approximate value of the output for the convenience of illustration.
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Integer type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 315 |
| D | E | F | 0 | 3 |
This operation is similar to the Product merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Integer type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 315 |
| A | B | C | 10 | 315 |
| A | B | C | 10 | 315 |
| D | E | F | 0 | 3 |
| D | E | F | 0 | 3 |
This operation returns the remainder when the values in the integer field are divided by a specified integer value.
| Field 1 | Value | Output |
|---|---|---|
| 50 | 3 | 2 |
| 2 | 3 | 2 |
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 2.0 |
| D | E | F | 0 | 1.4142* |
*This is an approximate value of the output for the convenience of illustration.
This operation is similar to the Standard deviation merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 2.0 |
| A | B | C | 10 | 2.0 |
| A | B | C | 10 | 2.0 |
| D | E | F | 0 | 1.4142* |
| D | E | F | 0 | 1.4142* |
*This is an approximate value of the output for the convenience of illustration.
This operation subtracts a specified integer value from the integer.
| Input | Value | Output |
|---|---|---|
| 50 | 1 | 49 |
| 2 | 1 | 1 |
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 21 |
| D | E | F | 0 | 4 |
This operation is similar to the Sum merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 21 |
| A | B | C | 10 | 21 |
| A | B | C | 10 | 21 |
| D | E | F | 0 | 4 |
| D | E | F | 0 | 4 |
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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output, which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 4.0 |
| D | E | F | 0 | 2.0 |
This operation is similar to the Variance merge operation. The differences are in the following:
It enables 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 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5 |
| A | B | C | 10 | 7 |
| A | B | C | 10 | 9 |
| D | E | F | 0 | 1 |
| D | E | F | 0 | 3 |
The following table shows an example of the output (Group Field: Field 1), which is in Float type:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 4.0 |
| A | B | C | 10 | 4.0 |
| A | B | C | 10 | 4.0 |
| D | E | F | 0 | 2.0 |
| D | E | F | 0 | 2.0 |