extracting values from datatable by index

[achen1]

How do I extract the value from the first row of the "longname" column from my datatable called "calc_attributes_data" 

[achen1]

53 minutes ago, achen1 said:

How do I extract the value from the first row of the "longname" column from my datatable called "calc_attributes_data" 

I am trying to dynamically change the title of my graph based on the value in the "longname" column of the first row

[Vanessa Virginia Sucre Gonzalez]

Hi @achen1

Could this script work for you?
 

from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Application.Visuals import *

#setup rows to select from rows to include
rowCount=table.RowCount
rowsToInclude = IndexSet(rowCount, True)
 
# Create a cursor to the Column we wish to get the values from
cursor = DataValueCursor.CreateFormatted(table.Columns["myCol"])
 
# Loop through all rows, retrieve value for specific column,
# Get the first value from the column
for row in table.GetRows(rowsToInclude, cursor):
	rowIndex = row.Index
	if rowIndex == 0:
		myTitleValue = cursor.CurrentValue
		break;


# Get myVis as a Visualization
myVis = VisualElement.As[Visualization]()

# Show (or hide) the title
myVis.ShowTitle = True

# Change the title
myVis.Title = 'My New Title has this value -> ' + myTitleValue

 

[achen1]

7 hours ago, Vanessa Virginia Sucre Gonzalez said:

Hi @achen1

Could this script work for you?
 

from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Application.Visuals import *

#setup rows to select from rows to include
rowCount=table.RowCount
rowsToInclude = IndexSet(rowCount, True)
 
# Create a cursor to the Column we wish to get the values from
cursor = DataValueCursor.CreateFormatted(table.Columns["myCol"])
 
# Loop through all rows, retrieve value for specific column,
# Get the first value from the column
for row in table.GetRows(rowsToInclude, cursor):
	rowIndex = row.Index
	if rowIndex == 0:
		myTitleValue = cursor.CurrentValue
		break;


# Get myVis as a Visualization
myVis = VisualElement.As[Visualization]()

# Show (or hide) the title
myVis.ShowTitle = True

# Change the title
myVis.Title = 'My New Title has this value -> ' + myTitleValue

 

how to I assign my crosstable to be my active table? The datatable is dynamic and will change based on the filters I apply so how can I set the "table" variable to be the data that is currently being displayed (after filters are applied)?

 

[David Boot-Olazabal]

Hi achen1,

There are two parameters that you have to set: table and Visual Element. The table would be your underlying data table and the Cross Table the Visual Element. See my example below, where I deactivated the ShowTitle line (line 23):

Now, when you want to apply filters, so your representation of the data is changing in the Cross table, the underlying data table doesn't change actually. It's only the representation.

You can either opt for a 'removal' of rows from the data table by marking the values and select to delete the marked values (this adds a transformation on the data table, you can remove by applying another script or manually via the data canvas), or you can try to copy the filtered data to a new data table and build your Cross Table on that newly created data table.

Kind regards,

David