Search code examples
spotfire

spotfire new table from file filtered

I am using spotfire client.

I have identified some records within a data table that I would like to send to a new data table. Is there some way to create a new table with marked or isolated data or using a data limiting expression on the source table? I have had to export my filtered data out and then import it back in but I am hoping there is a more direct way.

Thanks!

Solution

  • If you know the restrictions you need to set on your data to identify the records, you can create a second table based on the source data.

    Go to the properties of the table / visualization, then go to the Data tab. You have to scroll all the way to the bottom. There you can edit the "Limit data using expression".

    You could also create a detailed visualization if you want, but that is only useful if you can quickly identify the records.

    Or insert a calculated column (e.g. case statement) and use this column to filter your data.