How to Change the Join Type of an Add Columns Operation in Spotfire® using IronPython

Introduction

This example shows how to change the join type of an Add Columns operation using an IronPython script. The script is called from a Text Area Action Control, after the user has selected a join type from a dropdown. The attached analysis file contains the complete example with table plots that illustrates how the different join types are performed.

The example uses the Data Table Source View API (introduced in version 7.10).

Code Sample

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

from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Data.DataOperations import *
from System import *

op = table.GenerateSourceView().GetAllOperations[AddColumnsOperation]()[0]
old = op.AddColumnsSettings;
newSettings = AddColumnsSettings(old.Map, Enum.Parse(JoinType, joinType), old.IgnoredColumns, matchOnNull)
op.AddColumnsSettings = newSettings

References

• API Reference: DataTable.GenerateSourceView Method
• API Reference: SourceView Class
• API Reference: AddColumnsOperation Class
• API Reference: AddColumnsSettings Class
• Data Table Source View API Overview

License:  TIBCO BSD-Style License