How to replace the File DataSource of a Data Table in Spotfire® Using IronPython Scripting

Introduction

With Data Table Source View API you have the ability to view the source view of a data table and perform some operations on the data table. Below is a sample script to replace the file data source of an existing data table

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 Spotfire.Dxp.Data import DataFlowBuilder

table=Document.ActiveDataTableReference

sourceView=table.GenerateSourceView()
#get the dat atbale data source operation
op=sourceView.GetAllOperations[DataSourceOperation]()[0]

#build the data flow
dataSource= Document.Data.CreateFileDataSource(r"C:D121-02 Open-Perfect Format.csv")
dataFlow = DataFlowBuilder(dataSource, Application.ImportContext).Build()

#replace the data source
if op.CanReplaceDataFlow():
	op.ReplaceDataFlow(dataFlow)

References

• API Reference: DataTable.GenerateSourceView()
• API Reference: SourceView
• API Reference: DataSourceOperation

License:  TIBCO BSD-Style License