Selective Loading

Fri, 18 Sep 2009 21:05:05 GMT

Hello,

How would I perform a selective load?

For example, from an excel sheet, only loading into QlikView lines that meet the criteria Country Code = GBR?

Thanks,

Ryan

Selective Loading

Fri, 18 Sep 2009 21:08:20 GMT

When you use the table load wizard on an Excel file, you should get a Where option. It's on the Options (3rd) page under Clauses. Then use the wizard to create a Where clause to be Country Code = GBR.

Or you can just go to your existing Excel file load and add a Where like this:

...FROM
Sheet.xls
(biff, no labels, table is Sheet1$)
WHERE(CountryCode = 'GBR');

topic Selective Loading in QlikView

Selective Loading

Selective Loading