Discussion Board for collaboration related to QlikView App Development.
Hi Qlik Gurus,
I need help once again. I am trying to load a table and exclude a few items. However, I keep getting an error. Load works perfectly fine without my Where statement. Please advise how I can fix it.
LOAD * INLINE [
Assessment Status, Grouped Status
Complete, Draft Report Delivered
Planning, In Planning
In Progress, In Progress
Pending Business Response, In Progress
Pending Response from Business, In Progress
Pending Vendor Response, In Progress
Pending VRM Response, In Progress
ApplyMap('MappingTable', [Assessment Status]) as [Grouped Status]
(ooxml, embedded labels, table is [VRM Program Status]
WHERE not Match([Assessment Type],'Cancelled', 'Retired/Other');
I still believe it's just a small typo.
Could you post a screenshot of your current LOAD statement and another one of the error message?
View solution in original post
I think you are missing a closing parenthesis:
(ooxml, embedded labels, table is [VRM Program Status] )
still the same error message
Yes, it was a typo! Thank you! All works now!