Why does filter 'where' not work

[Edyta]

Hi guys,

It must be easy but I cannot figure it out.

I have straight table data with columns: client, month, production cost, raw material cost.

My code is as below:

[JohnLewis]:
Load
*
resident RawData
where Match([Client], 'John Lewis');

drop table RawData;

After loading data, table RawData is loading, the filter does not work. Could you assist?

[JordyWegman · Accepted solution]

Hi Edyta,

What you want is the following:

[JohnLewis]:
Load
*
resident RawData
where Client = 'John Lewis';

drop table RawData;

Because Match is now returning you 1 and it not filtering.

Jordy

Climber

[Edyta]

I have tried it previously and this does not work too. I cannot also filter in other apps. No idea why.

[Edyta]

It's like qlik does read filter and do not drop table RawData.

RawData is loading in full.

[JordyWegman]

Hmm what is exactly the problem now? That you don't get the John Lewis files or that the RawData table is still there?

Jordy

Climber

[Edyta]

I solved it! there was a problem with loaded data.

Thank you for your engagement.

[florentina_doga]

noconcatenate
[JohnLewis]:
Load
*
resident RawData
where Match([Client], 'John Lewis');

drop table RawData;