Perspective Table, selecting multiple rows and getting each selected row number (index)?

[drewdin]

I have a perspective table with a json dataset, I want to remove rows that I have filtered from the dataset.

Removing one row is easy as the selectedRow property in selection is populated but when I have multiple rows selected, the selectedRow property only has the last row i clicked, not the list selected.

selection/data and filter/data properties only have the selected row values, not the row numbers

Is it possible to get the list of selected rows numbers from the table?

[dkhayes117]

Is your data coming from a query or from a tag/static source?

[lrose]

You need to give your rows a unique identifier, even if it is hidden, then use that to remove the rows by id.

[drewdin]

I'm reading an excel doc and populating a dataset into a table. I don't have any unique identifiers and I was hoping to use the row index if possible, i found another post that manually creates the index based on counting the rows. I might do that as I delete items from the table, the row numbers will change.

[dkhayes117]

Right, the rows need to be enumerated so they have some sort of index to identify the rows to be removed explicitly. The implicit row numbers from the component would not be ideal.

[pturmel]

Move the table data binding to custom property. Process the original data to add a column of row indices and provide that to the table's props.data.

Selected rows rowindexes

I generally post-process the table source data with my toolkit selectStar() function to add a column containing the original data row index within the table data. As long as this is present in props.columns, usually hidden, this extra index will show up in rowData as well as filtered and sorted feedback properties.