How do I select all rows below a specific value?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?Your script worked perfectly! Thank you so much!
Re: How do I select all rows below a specific value?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=""></GET>
