While registering a data function, only "None" input handler type is available for a table (or column) type input parameter.

While registering a data function, only "None" input handler type is available for a table (or column) type input parameter.

While registering a data function, it is necessary to specify a mapping of all required parameters to Spotfire in order to use the data function. The input parameters of a data function are mapped to input handlers based upon the type of input parameter that is selected(Value, Column or Table). See "Details on Edit Parameters" for more information on input handlers.

In some cases, a user can observe that no input handler (apart from "None") is listed in the input handler section for a table(or column) type input parameter:

Generally, the input handler section lists all the input handlers that are available to be mapped to the input parameter. For a table (or column) type input parameter, the available input handlers are "Column", "Expression", and "None", but this is true only while working with "In-Memory" data tables. Data function execution using R/TERR is only supported for imported data tables (In-Memory tables) and not "In-Database" tables. If your analysis contains only "In-Database" table(s), you will observe only "None" as the available input handler. 

This unavailability of data function feature while working with data from an external data source (in-database) is documented here: https://docs.tibco.com/pub/spotfire/6.5.1/doc/html/data/data_working_with_in-database_data.htm

To resolve this, one can use either of the below options:

1.    Import the In-Db data table. See "Adding Data Tables" for more details.
2.    Keep the current data table In-DB and add an imported On-Demand data table which is loaded based on the marking in the external data table. See "Data on demand" for more details. Doc: Details on Edit Parameters: https://docs.tibco.com/pub/spotfire/6.5.0/doc/html/df/df_details_on_data_functions_parameters.htm


Doc: Adding Data Tables: https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connect/connect_adding_data_connections_to_an_analysis.htm

Doc: Data on Demand: https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/add/add_loading_data_on_demand.htm

Doc: Working With In-Database Data: https://docs.tibco.com/pub/spotfire/6.5.1/doc/html/data/data_working_with_in-database_data.htm