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;

1 Solution

Accepted Solutions
rbecher
MVP
MVP

You probably have to use


D_ShowAllBr:

NOCONCATENATE LOAD...

Astrato.io Head of R&D

View solution in original post

15 Replies
MK_QSL
MVP
MVP

Try as below

D_ShowAllBr:

Load *

Resident D_ShowAllBrtmp

where [Entity ID] <= NUM(10);

Not applicable
Author

Thanks Manish, but I have the same issue .. 0 returned values and no table created ..

As soon as I remove the where .. table creates with all values ..

rustyfishbones
Master II
Master II

you can try

D_ShowAllBr:

LOAD *

RESIDENT D_ShowAllBrtmp

where [Entity ID] <= 11;

DROP Table D_ShowAllBrtmp;

rbecher
MVP
MVP

You probably have to use


D_ShowAllBr:

NOCONCATENATE LOAD...

Astrato.io Head of R&D
Not applicable
Author

Thanks, same result. No table.

maxgro
MVP
MVP

does it returns no value or no table?

it seems you're missing a noconcatenate as you load *

EDIT:ops,I'mlate

Not applicable
Author

Spot on and thanks ..

rustyfishbones
Master II
Master II

Why would he have to use NOCONCATENATE

If the Table is being Dropped?

rbecher
MVP
MVP

Because it's appending to the already existing table (same structure), which gets dropped at the end. So, no data loaded at all...

Astrato.io Head of R&D