CODEWITHSUNDEEP
spotfire
cookiemnstr247
cookiemnstr247

Reputation: 131

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!

Upvotes: 1

Views: 2035

Answers (1)

phiver
phiver

Reputation: 23598

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.

Upvotes: 2

Related Questions