Spotfire - Handling of SQL BIT field


Version: TIBCO Spotfire Analyst 7.10.1

The issue I have is that Spotfire's default behaviour when reading data in from a Microsoft SQL Server connection is to map BIT fields to BOOLEAN. In doing so, BIT values of NULL are converted to FALSE which is a misintepretation of the data.

I have tried handling via a transformation, but I can only add one after data has been loaded into Spotfire such that the mapping described above has already occurred.

Has anybody previously encountered this situation previously? And, if so, can you recommend a solution?

(1) Answer