Load data

[#1]

Is it possible to load data with a filter.

We only want records with status Completed loaded. So how to filter the load of data on this criteria.

John

[Gysbert_Wassenaar]

With a where clause. Something like this:

Table1:

Load *

from mysource

where Status = 'Completed';

If you load date from an sql database you can include the where statement in the sql statement

Select * from mytable

where Status = 'Completed';

[#3]

TRY ACCORDING TO THIS

DATA:

Load *

from DATATABLE

where match(id,'404','408','522');

sql select * from source;

[Gabriel]

Hi,

Yes, you can load data with filter. As fellow QV experts have suggested you can use WHERE clause both in SQL statement or in QlikView script (assuming you just load all the data from source , database, flat files i.e. Excel, CSV, without filter).

So something like this: ALL THIS IN QV SCRIPT

Select top(10) *

from YourSource: (From database)

Where JobStatus = 'Complete