Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load Where Match

I have looked through the forums and found the advice on how to load specific (Or exclude specific as the case may be) records from a qvd and it seems very simple, but i cannot get it to work - I get the error listed below the example.  What am I missing?

Sites:

Load *  FROM $(vQVDPathRepository)$(vQVDRepositoryFilePrefix)SVMXC_Site.qvd (qvd) 

Where Match (SVMXC_Site_Movex_Id, 

10313_905_2,

10461_003_2,

10585_003_2,

11572_003_2,

11572_004_2,

11604_001_2,

17661_001_2,

18100_004_2) ; 

Error in expression: ')' expected

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I figured it out, single quotes '10313_905_2' required,

and ...')>0; required at end

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I figured it out, single quotes '10313_905_2' required,

and ...')>0; required at end