Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selective Loading

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

1 Solution

Accepted Solutions
Not applicable
Author

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');


View solution in original post

1 Reply
Not applicable
Author

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');