Data Export -- for large data sets, is there a way to limit the number of rows that can be exported from the Web Player?
Article ID: KB0081906
Updated On:
| Products | Versions |
|---|---|
| Spotfire Web Player | All |
Description
For large data sets, is there a way to limit the number of rows that can be exported from the Web Player?
Issue/Introduction
Data Export -- for large data sets, is there a way to limit the number of rows that can be exported from the Web Player?
Environment
Windows
Resolution
The Web Player's data export feature does not provide user control over the number of rows to be exported.
When a Table visualization is in focus, the Data Export feature exports only the columns that are included in the Table visualization, and only the rows that are displayed as a result of the current filter selections for that Table visualization. You could insert a calculated column into the data table, using the RowId() function to assign a unique integer to each row, then include that column in the Table visualization and specify a range filter as the filter type for that column. Then the Web Player user would be able use the range filter for that RowId column to select a range of RowId values to be included in the export, each time they use the Data Export feature.
For example, to limit each data export to 2000 rows, the Web Player user could select the following ranges of values for the RowId column for the first three data exports:
1 to 2000
2001 to 4000
4001 to 6000
If no other filters were also limiting the data displayed in the Table visualization, this would export a total of 6000 rows in three groups of 2000 rows each, with no overlap.
When a Table visualization is in focus, the Data Export feature exports only the columns that are included in the Table visualization, and only the rows that are displayed as a result of the current filter selections for that Table visualization. You could insert a calculated column into the data table, using the RowId() function to assign a unique integer to each row, then include that column in the Table visualization and specify a range filter as the filter type for that column. Then the Web Player user would be able use the range filter for that RowId column to select a range of RowId values to be included in the export, each time they use the Data Export feature.
For example, to limit each data export to 2000 rows, the Web Player user could select the following ranges of values for the RowId column for the first three data exports:
1 to 2000
2001 to 4000
4001 to 6000
If no other filters were also limiting the data displayed in the Table visualization, this would export a total of 6000 rows in three groups of 2000 rows each, with no overlap.
Feedback
Yes
No
Powered by
