topic Re: Loop for Deleting Rows in Discussions

Loop for Deleting Rows

Jemster — Fri, 09 Jun 2023 17:05:17 GMT

I have a loop for deleting rows where the column value isn't what I want

When I run the loop I keep the first set of rows meeting my specifications then it deletes all other rows. I am importing from an excel file and it has several rows in succession of what I want then a gap with other data then later another several. I only get the first set

N_loop = N Rows(dt_a);
i_loop = 0;

While(N_loop > i_loop,
	If( And(dt_a:Column 7[N_loop] != "example 1", dt_a:Column 7[N_loop] != "example 2"),
		dt_a << Delete Row(N_loop)
	);
	N_loop = N_loop - 1
);

Re: Loop for Deleting Rows

Jemster — Mon, 25 Jul 2022 08:15:55 GMT

The code works fine. I was searching in the wrong column

Re: Loop for Deleting Rows

txnelson — Mon, 25 Jul 2022 12:18:35 GMT

You might also try

select where( dt_a:Column 7[N_loop] != "example 1" & dt_a:Column 7[N_loop] != "example 2" );
dt_a << delete rows;