59892_en-US

liliconcom

Is it possible to use "WHERE Clause editor" not from File > Database > Open Table?

 Below "WHERE Clause editor" is very nice to check queries via built-in functions. But it seems to use it only from "from  File > Database > Open Table". I'd like to know how to use "WHERE Clause editor" in JSL not from database.

 

 

Re: Is it possible to use "WHERE Clause editor" not from File > Database > Open Tab

Thank you. But my question is I'd like to check SQL queries within "WHERE Clause editor" not from  "File > Database > Open Tab". Because in Query Editor window, there is No helpful tool as like "WHERE Clause editor", I should check query syntex every day. If any tool as like "WHERE Clause editor" in Query Editor exits, it will be very helpful to write queries in Query Editor.

Re: Is it possible to use "WHERE Clause editor" not from File > Database > Open Tab

The Where clause is a Boolean expression. As such, if you have a sample of data in a JMP data table, you could create a numeric data column and use the column Formula Editor to make the expression and test it.