How to set key columns for a given data table in Spotfire® using IronPython scripting.

Introduction

Below is a scripting example to set the Key columns in Spotfire.

Code sample

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

from Spotfire.Dxp.Data import *
from System.Collections.Generic import List

table = Document.Data.Tables["table1"]
primayCol = table.Columns[0] #Primary column .. 
s = List[DataColumn]()
s.Add(primayCol)

table.PrimaryKey = s

References

• API Reference: Spotfire Analyst
• API Reference: DataTable.PrimaryKey Property

License:  TIBCO BSD-Style License