Deleting Similar Rows

S_Boilermaker — Fri, 14 Jun 2024 16:52:29 GMT

I'm trying to create a script that will delete a row from my table if the ID and two values are the same as the row before it. I cant delete all duplicate rows because there is a "run number" column that is unique to each row. Does anyone know why my code isn't working?

// Delete Duplicate Rows (re-entries)
NRows = N Rows(dt);
For(i = 1, i <= NRows, i++,
	If(
		dt:ID[i] == dt:ID[i + 1] & Data Table("Sheet1"):value1[i] == dt:value1[i + 1] & dt
		:value2[i] == dt:value2[i + 1],
		{dt << Delete Rows(i), i--}
	)
);

Re: Deleting Similar Rows

Jed_Campbell — Fri, 14 Jun 2024 14:49:40 GMT

I think this portion of your script in the braces is where things are going wrong (the if() function doesn't generally want braces there):

{ dt << Delete Rows (i), i --}

That being said, here's another, perhaps simpler way to get what you want, using JMP's built-in function for selecting duplicates:

dt << Select Duplicate Rows ({:ID, :Value 1, :Value 2});
dt << delete rows;

topic Deleting Similar Rows in Discussions

Deleting Similar Rows

Re: Deleting Similar Rows