lilysecret icon

Select Rows by Criteria and Delete JMP JSL

lilysecret | PRO | 09/25/23 04:37:30 PM UTC (Edited) | 0 ⭐ | 367 👁️ | Never ⏰ | [JMP, JSL]
text |

820 B

|

None

|

0 👍

/

0 👎

//open the file and assign an easy handle (dt) to the current data tables
Names Default to Here(1);
 dt = current data table();
 //select rows based on ID number and delete them
Current Data Table() << Row Selection(	
	Select where(
		:"Respondent ID - RCL"n == 53666296 |
		:"Respondent ID - RCL"n == 53600883 |
		:"Respondent ID - RCL"n == 53601444 |
		:"Respondent ID - RCL"n == 53668132 |
		:"Respondent ID - RCL"n == 53603576 |
		:"Respondent ID - RCL"n == 53673565 |
		:"Respondent ID - RCL"n == 53610794 |
		:"Respondent ID - RCL"n == 53665615 |
		:"Respondent ID - RCL"n == 53614508 |
		:"Respondent ID - RCL"n == 53677457 |
		:"Respondent ID - RCL"n == 53600299 |
		:"Respondent ID - RCL"n == 53666008 |
		:"Respondent ID - RCL"n == 53600294 |
		:"Respondent ID - RCL"n == 53666998
		));
 dt << delete rows;
 

Comments