topic How do I select all rows below a specific value? in Discussions

How do I select all rows below a specific value?

Raquel — Thu, 29 Nov 2018 13:51:07 GMT

Hello,

Is there a way in JSL to select all rows below a specific value in a column? The tricky part is that I know what the specific value is but I won't know which row it is on or what values may fall below it in the data table.

In my Example Data Table, I would like to select where Column 3 == "B" and all subsequent rows. After running the script, rows 4 through 15 should be selected. Keep in mind that the data table will change and I won't know which row "B" will start on or what "A", "X", "Y" and "Z" are or how many rows are in the data table.

Re: How do I select all rows below a specific value?

txnelson — Thu, 29 Nov 2018 14:02:15 GMT

I think this script will get you what you want

names default to here(1);
dt=current data table();

dt << select where(
	row()>=min(dt<<get rows where(:Column 3=="B"))
);

Re: How do I select all rows below a specific value?

Raquel — Thu, 29 Nov 2018 14:21:38 GMT

Your script worked perfectly! Thank you so much!