Perform operations on the columns in a Graphical Table

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

from Spotfire.Dxp.Application.Visuals.Miniatures import GraphicalTable from Spotfire.Dxp.Application.Visuals import VisualTypeIdentifiers for col in gtable.As[GraphicalTable]().Columns: #Calculated Value Columns if col.Visualization.TypeId == VisualTypeIdentifiers.CalculatedValueMiniatureVisualization: try: vExp = col.Visualization.ValueAxis.Expression except: 0 #Icon Columns if col.Visualization.TypeId == VisualTypeIdentifiers.IconMiniatureVisualization: try: vExp = col.Visualization.IconAxis.Expression except: 0 #Sparkline Columns if col.Visualization.TypeId == VisualTypeIdentifiers.SparklineMiniatureVisualization: try: vExp = col.Visualization.YAxis.Expression except: 0 #Bullet Graph Columns if col.Visualization.TypeId == VisualTypeIdentifiers.BulletGraphMiniatureVisualization: try: vExp = col.Visualization.ValueAxis.Expression except: 0 try: col.Title = vExp except: 0

Input:
gtable (Graphical Table)

This script will loop over the columns in a Graphical Table, find the expression used, and set the column title to display the expression.