Excluding when Loading

[#1]

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.

MappingTable:

Mapping

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

Retired/Other,

Cancelled,

];

LOAD

[Assessment Status],

      ApplyMap('MappingTable', [Assessment Status]) as [Grouped Status]

FROM

(ooxml, embedded labels, table is [VRM Program Status]

WHERE not Match([Assessment Type],'Cancelled', 'Retired/Other');

ERROR Message

[swuehl]

I think you are missing a closing parenthesis:

FROM

(ooxml, embedded labels, table is [VRM Program Status] )

[#3]

still the same error message

[swuehl · Accepted solution]

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?

[#5]

Yes, it was a typo! Thank you! All works now!