Choose Language Hide Translation Bar
Highlighted
rverma
Occasional Contributor

Excluding Rows from subset and main data table

Hello,

I have a main data table and based on values in a particular column of this table, I create a subset (All columns, selected rows). Now I calculate some summary statistics on this subset and based on certain criteria exclude some of the rows in the subset table. I also want these rows to be excluded from the main table which is not happening currently. How can I exclude the same rows from subset and main table at the same time? Any guidance will be highly appreciated.

 

Thanks

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Excluding Rows from subset and main data table

You can use the "Link to Original Data Table" option when you subset the data table.  Do your analysis, and then in the subsetted data table, you can select which rows you want deleted.  You can then go back to the original data table where the selected rows in the subsetted table will have also been selected in the original table, and delete the selected rows.  You will not be able to delete them from the subsetted table, you have to go back to the original data table to do the deletions..

Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

Re: Excluding Rows from subset and main data table

You can use the "Link to Original Data Table" option when you subset the data table.  Do your analysis, and then in the subsetted data table, you can select which rows you want deleted.  You can then go back to the original data table where the selected rows in the subsetted table will have also been selected in the original table, and delete the selected rows.  You will not be able to delete them from the subsetted table, you have to go back to the original data table to do the deletions..

Jim

View solution in original post

Highlighted
rverma
Occasional Contributor

Re: Excluding Rows from subset and main data table

Thanks Jim. I needed it for my JSL script. As per your suggestion I included word Linked when creating subset and it did exclude the rows in the main table as well.
<< Subset(Selected Rows,Linked);

Thank you very much.
0 Kudos