topic Re: Excluding when Loading in QlikView

Excluding when Loading

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Excluding when Loading

swuehl — Wed, 25 May 2016 20:53:49 GMT

I think you are missing a closing parenthesis:

FROM

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

Re: Excluding when Loading

Wed, 25 May 2016 20:56:47 GMT

still the same error message

Re: Excluding when Loading

swuehl — Wed, 25 May 2016 21:04:08 GMT

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?

Re: Excluding when Loading

Wed, 25 May 2016 21:06:55 GMT

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