How to change 'NULL' values in column to blank values

Hi All,

 

I am trying to connect data from SQL DB, and there are NULL values in many columns. While Connecting to spotfire using SQL (using ISNULL function) these NULL values are changed to 0. 

Since these values are changed to 0 there are few calculations being executed.

I wanted to change these NULL to blank instead of Zero, is this possible?

(1) Answer

Login