An INT function can be used to convert a float into an integer.


INT(col) : float


In the example below, we take a float (‘foo’) and cast into an integer (at which point it becomes 5) and then use the ISINT within an IF statement to evaluate if it is a float or not.

gorrow 1,1,1 | CALC foo 5.0 | CALC bar int(foo) | CALC int? IF(ISINT(bar),'true','false')