Created:
| Last Modified:
Hi
Probably a very basic question but I can't find an easy way to clear only a portion of data in a column.
In Graph builder, I have selected only data after a specific date (May 10th) but from that point I don't how to clear the data in column "ABS(PV-SP) T804" only for the selected rows and not for all the columns.
Thanks in advance for any help.
1 ACCEPTED SOLUTION
Accepted Solutions
When you have your rows selected which you want to clear
while holding ALT press on the column name you want to remove the values from
you should end up values selected only from that column. Then you can press delete to remove the values (or set them as missing)
But I wouldn't really suggest doing this in JMP. Depending on what you are doing and the format of your data there might be better options such as hide and exclude row and set missing value codes column property.
When you have your rows selected which you want to clear
while holding ALT press on the column name you want to remove the values from
you should end up values selected only from that column. Then you can press delete to remove the values (or set them as missing)
But I wouldn't really suggest doing this in JMP. Depending on what you are doing and the format of your data there might be better options such as hide and exclude row and set missing value codes column property.