If you are familiar with the Load statement or the SQL Select statement, it will be easy for you to filter the data while loading it. In the script editor, the best way to restrict the data is to include the Where clause at the end of the Load or Select statement; for example, Where Date >= '01/01/2012'.
When you use the Where clause with the Load statement, you can use the following conditions:
- =
- >
- >=
- <
- <=
When you write the Where clause with the SQL Select statement, you can use following conditions:
- =
- >
- >=
- <
- <=
- In
- Between
- Like
- Is Null
- Is Not Null
The following screenshot shows an example of both the statements: