Select Column to send to data function from a document property

[David Katz]

I have a document property with the name of an existing table column. How do I configure a data function so that it only sends that column of the table to TERR?

[Gaia Paolini]

If you only want to select a single column (say defined via document property ColumnToSelect)

then when you are specifying the parameters to your data table, choose Expression as Input handler

and type the following custom expression in the expression editor:

[iris].[${ColumnToSelect}]

in this example I am using a data table called iris, change the name to yours but make sure it is also selected as a data table

at the top of your expression (see TOP picture) otherwise Spotfire will complain that it does not find the table.

If you want to send multiple columns (defined via a multi-selection document property ColumnsToSelect)

then use the following expression: (see SECOND picture)

$map("[iris].[${ColumnsToSelect}]", ",")

which is actually typed for you automatically if you go and select the document property and right click on it 

on the Available properties for column list above the expression editor.

[David Katz]

Thanks Gaia!