Cannot use Boolean columns as input to on-demand data tables in Spotfire
Article ID: KB0070336
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.0 and lower |
Description
Cannot use Boolean columns as input to on-demand data tables.
When defining the inputs for an on-demand data table, columns of data type Boolean are not present in the list of available columns, despite being present in the data table selected. The list of columns available for use as on-demand table input is defined here:
- On-Demand Settings > Define Input > Input from selected parameter: Values from Column > Settings: Column
Columns of data type Boolean are not supported as an input to on-demand data tables. This is due to issues that some databases have with Boolean data types.
Resolution
The workaround is to create a new Calculated Column of a different data type that contains the same TRUE/FALSE information, then use the calculated column as the input for the on-demand data table. The calculated column can be an integer data type (with values 1 and 0), for example, or it can be a string data type (with values 'TRUE' and 'FALSE').
Examples:
- Integer Data Type: if([myBooleanColumn]=TRUE, 1, 0)
- String Data Type: if([myBooleanColumn]=TRUE, 'TRUE', 'FALSE')
Then use this new Calculated Column when defining your on-demand data table input.
Issue/Introduction
Feedback
