Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Where - Resident issue

I have a table loaded within a script that is populated with some data not required - I want to limit the data by using the resident command to load a new table with a subset of the data.

As an example the image below show a Entities and Entity ID's currently in the table - I want to reduce them to those with an [Entity ID] of less than 11

Qlk_Entity.png

I tried the following , but it returns no values into the new table

D_ShowAllBr:

Load *

Resident D_ShowAllBrtmp

where Match([Entity ID],'1' ,'2' , '3', '4', '5', '6', '7', '8', '9', '10');

I have tried Wild Match and < 11 as an option .. each time I get an empty table

I am unable to use the SQL in the initial query to limit it due to an issue with the adapter returning the data ..

Any pointers please.

Drop Table D_ShowAllBrtmp;

15 Replies
Not applicable
Author

I would ask the same .. but placing NoConcatenate into the Load section seems to have done the trick .. not had to do it before ...

rustyfishbones
Master II
Master II

Hi Ralf,

So what if he aliased one of the Fields

so like

NewTable:

LOAD *,

Code as NewCode

RESIDENT Data

where Code <= 11;

DROP Table Data;

Then you would not need NOCONCATENATE, is that correct?

rbecher
MVP
MVP

What's wrong with NOCONCATENATE? It's the better way, I think..

Astrato.io Head of R&D
rustyfishbones
Master II
Master II

nothing wrong with NOCONCATENATE

just trying to get a better understanding of how it works, that's all!

rbecher
MVP
MVP

Extra field would probably work but consumes more memory and time..

Astrato.io Head of R&D
rustyfishbones
Master II
Master II

Excellent Ralf,

Thanks

Regards

Alan