How to add a Hierarchy Column to Data Table in Spotfire® using IronPython Scripting

Introduction

Below is a sample script on how to add a Hierarchy column to an existing table

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["Data Table"]

#list of expressions and Add a Expression
expressions=List[str]()
expressions.Add(" [Continent]")
expressions.Add("[Country]")

#define HierarchyDefinition
definition=HierarchyDefinition(HierarchyNestingMode.Nested,expressions )

#add column
table.Columns.AddHierarchyColumn("New Hierarchy Column",definition)

References

• API Reference: HierarchyDefinition
• API Reference: AddHierarchyColumn

License:   TIBCO BSD-Style License