Replace Column if not available like SN Function

[Aditya Singh 3]

Hi, I have acalculated column where one column will be loaded for few dates but not always. So my calculation is like-

Calculated Col= [Column1 + [Column2].

When both the columns are availavle, the calculation works fine but when one of the column is missing, then calculation gives error. Is there any way to replace column with 0 if it's not available like we do for SN function.

[Paul Shumaker]

If([Column1] IS NULL, 0, [Column1] ) + If([Column2] IS NULL, 0, [Column2])

[Aditya Singh 3]

Thanks but this expression is aplicable to null values of column not when Column itself it not available(not loaded in datatable).

[Fabian Duerr]

I don't think that this is possible...

 

But as I workaround I would try to ensure that your source data is consistent. So maybe you could check during data load if this column is available and if not you create it filled with 0. Or fix the issue right in your source data.

[Gaia Paolini]

I tried to solve a similar problem (inconsistent columns) with Iron Python here:

 

https://community.spotfire.com/questions/adding-blank-column-using-ironpython

 

maybe useful 

[Aditya Singh 3]

Thanks, but the source which I am using does not allow to write custom queries. I have to aload whatever is available. There are few columns which are available for some periods like only in 2012 but not in other years.