How do I select all rows below a specific value?

[#1]

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.

[#2 · Accepted solution]

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"))
);

[#3]

Your script worked perfectly! Thank you so much!