Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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');
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');