David Katz Posted November 9, 2022 Share Posted November 9, 2022 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? Link to comment Share on other sites More sharing options...
Solution Gaia Paolini Posted November 10, 2022 Solution Share Posted November 10, 2022 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 handlerand 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 tableat 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. Link to comment Share on other sites More sharing options...
David Katz Posted November 10, 2022 Author Share Posted November 10, 2022 Thanks Gaia! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now