cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
LogitTurtle576
Level III

How to clear data in one column for some specific rows ?

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.

 

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to clear data in one column for some specific rows ?

When you have your rows selected which you want to clear

jthi_0-1653411365569.png

while holding ALT press on the column name you want to remove the values from

jthi_1-1653411382759.png

you should end up values selected only from that column. Then you can press delete to remove the values (or set them as missing)

jthi_2-1653411419851.png

 

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.

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: How to clear data in one column for some specific rows ?

When you have your rows selected which you want to clear

jthi_0-1653411365569.png

while holding ALT press on the column name you want to remove the values from

jthi_1-1653411382759.png

you should end up values selected only from that column. Then you can press delete to remove the values (or set them as missing)

jthi_2-1653411419851.png

 

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.

-Jarmo
LogitTurtle576
Level III

Re: How to clear data in one column for some specific rows ?

Thanks for your help.

The ALT key tip is exactly was I was looking for.