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

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

LogitTurtle576 — Sat, 10 Jun 2023 23:48:54 GMT

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.

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

jthi — Tue, 24 May 2022 16:59:30 GMT

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.

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

LogitTurtle576 — Wed, 25 May 2022 12:11:44 GMT

Thanks for your help.

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