KNOWLEDGE BASE
Error "Bad int64 value" Using FLOAT() on a String field in Google BigQuery
Published: 24 Nov 2016
Last Modified Date: 30 Jan 2017
Issue
Using FLOAT () on a string field containing a decimal separator (ex: 12345.67), the following error occurs:
Bad int64 value 12345.67
Environment
- Tableau Desktop 10.1.0 - 10.1.2
- Google BigQuery
Resolution
Option 1:
Upgrade to Tableau Desktop 10.1.4 or a newer version. For more information, see Upgrade Tableau Desktop.
Option 2:
Instead of:
FLOAT([DimensionName])
Use:
RAWSQL_REAL("CAST (%1 AS FLOAT64)", [DimensionName])
Cause
This behavior is related to a known issue which has been corrected in more recent versions.