How to check if there are empty values in a column in Spotfire® Using IronPython Scripting

Introduction

Below is a sample code on how to check if there are any empty values in a column. 

Code Sample

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

from Spotfire.Dxp.Data import *

table=Document.Data.Tables["BASEBALL"]
column=table.Columns["AT_BATS"]
rowValues=column.RowValues.InvalidRows

if rowValues.Count>0:
	print column.Name+" column has "+ str(rowValues.Count)+" empty values"

References

• API Reference: Column.RowValues
• API Reference: InvalidRows

License:  TIBCO BSD-Style License