Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

Re: Load Where - Resident issue

You probably have to use


D_ShowAllBr:

NOCONCATENATE LOAD...

15 Replies

Re: Load Where - Resident issue

Try as below

D_ShowAllBr:

Load *

Resident D_ShowAllBrtmp

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

Not applicable

Re: Load Where - Resident issue

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
Honored Contributor II

Re: Load Where - Resident issue

you can try

D_ShowAllBr:

LOAD *

RESIDENT D_ShowAllBrtmp

where [Entity ID] <= 11;

DROP Table D_ShowAllBrtmp;

MVP
MVP

Re: Load Where - Resident issue

You probably have to use


D_ShowAllBr:

NOCONCATENATE LOAD...

Not applicable

Re: Load Where - Resident issue

Thanks, same result. No table.

MVP
MVP

Re: Load Where - Resident issue

does it returns no value or no table?

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

EDITSmiley Surprisedps,I'mlate

Not applicable

Re: Load Where - Resident issue

Spot on and thanks ..

rustyfishbones
Honored Contributor II

Re: Load Where - Resident issue

Why would he have to use NOCONCATENATE

If the Table is being Dropped?

MVP
MVP

Re: Load Where - Resident issue

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

Community Browser