How to exclude values from table in load statement
I am trying to load a table to QV but exclude rows where column A = 'X'. What is the syntax for this? I thought I could just add a WHERE statement but can't find the correct way to do this. Here is my code currently:
Re: How to exclude values from table in load statement
I have the where statement figured out but still trying to understand why you advocate saving my tables as qvd. Will this improve processing time within the application (pivot table calculations when filtering)? Will this save space?