Search code examples
ironpythonspotfire

select datatable list in spotfire


I am trying to put filter on datatable name in dropdown, for which i need list of datatable in my analysis page. How to list down all datatables name so that i can select them in drop down and then show data specific to data table in tabular view.

import Spotfire.Dxp.Data.DataTable
from Spotfire.Dxp.Data import *

dataTable = Document.Data.Tables['dataTableName']

for column in dataTable.Columns:
    print column

Above gives me column for the data table name i supply, but what i need is list of datatables and then put them into dropdown filter to select specific data table.


Solution

  • from Spotfire.Dxp.Data import *
    
    for x in Document.Data.Tables:
        print x.Name
    

    You can then assign the values that get kicked out of the loop to a document property, and use that in a drop down/to set another document property if needed.