Renaming the column name in SQL without data loss

EXECUTE sp_rename 'SchemaName.TableName.CurrentColumn', 'New Column', 'COLUMN';

Spotfire Interview Questions

https://intellipaat.com/interview-question/spotfire-interview-questions/?utm_source=link%2Fsfiq_MF&utm_medium=posting&utm_campaign=link%2Fsfiq_MF%20posting

Change Data Table Using Python Script in Spotfire

Change Data Table


##### Change Data table

from Spotfire.Dxp.Application.Visuals import VisualContent

tbl = currentTableVisualization.As[VisualContent]()
newtbl = Document.Data.Tables.Item['Data']
tbl.Data.DataTableReference=newtbl
tbl.AutoConfigure()
tbl.ApplyUserPreferences()

Assign marked values to Porperty control and redirect to new page

from Spotfire.Dxp.Data import DataValueCursor
myLatCursor = DataValueCursor.CreateFormatted(Document.Data.Tables["IL_GetStatus"].Columns["Project_ID"])
markedRows = Document.Data.Markings["StatusReportMarking"].GetSelection(Document.Data.Tables["IL_GetStatus"]).AsIndexSet()
for row in Document.Data.Tables["IL_GetStatus"].GetRows(markedRows, myLatCursor):
 Document.Properties['JobID'] = myLatCursor.CurrentValue
 Document.ActivePageReference = Document.Pages[2]

Spotfire IronPython: Reset Markings

https://techgoje.wordpress.com/tag/spotfire-ironpython/