Iron Python script to set Lines & Curves Y-values column in ScatterPlot

[Jonathan Guthrie]

I have a Python script as follows to change the YColumnReference in Lines & Curves in a ScatterPlot (screenshot of parameters attached)

from Spotfire.Dxp.Application.Visuals import *

sp = vis.As[scatterPlot]()

for fm in sp.FittingModels:

if fm.TypeId.DisplayName == "Line from Column Values":

if fm.Line.DisplayName == "Fit Data":

print fm.Line.DisplayName

print FittingModelCurve

fm.YColumnReference = FittingModelCurve

print fm.YColumnReference

which displays the following Error:

Fit Data

Modified Arps (Secant).0

Traceback (most recent call last):

File "", line 9, in

TypeError: expected DataColumn, got str

Any thoughts

[Shandilya Peddi]

The YColumnReference takes a DataColumn as an argument, so you should set that to a DataColumn and not a plain String.

It should be something as below

fm.YColumnReference = Document.Data.Tables["enter your Table Name"].Columns["COlumnNAme"]https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire-a...

[Jonathan Guthrie]

Thanks Shandilya!  Now working.