toInt() function
toInt() converts all values in the _value column to integer types.
Supported types and behaviors
toInt() behavior depends on the _value column type:
| _value type | Returned value |
|---|---|
| string | Integer equivalent of the numeric string |
| bool | 1 (true) or 0 (false) |
| duration | Number of nanoseconds in the specified duration |
| time | Equivalent nanosecond epoch timestamp |
| float | Value truncated at the decimal |
| uint | Integer equivalent of the unsigned integer |
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B, _value: int}]
For more information, see Function type signatures.
Parameters
tables
Input data. Default is piped-forward data (<-).
Examples
- Convert a float _value column to integers
- Convert a boolean _value column to integers
- Convert a uinteger _value column to an integers
Convert a float _value column to integers
import "sampledata"
sampledata.float()
|> toInt()
Convert a boolean _value column to integers
import "sampledata"
sampledata.bool()
|> toInt()
Convert a uinteger _value column to an integers
import "sampledata"
sampledata.uint()
|> toInt()
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.