Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Load only specific values

I have a spreadsheet that has a column (Material) that contains thousands of values.  I've isolated all of the values (thousands) that I do not want to load in a separate workbook (ExcludedMaterials). Now I'm looking for a way to load the entire spreadsheet except the rows where the value in the Material column matches a value specified in the ExcludedMaterails workbook. 

Is there a function that allows you to load all values except those specified in another list?  Thanks for any and all help!

1 Solution

Accepted Solutions
MVP
MVP

Re: Load only specific values

Try something like this:

Excluded:

LOAD Material as ExcludedMaterial

FROM ExcludedFile;

Table:

LOAD Material,

           AllOtherColumns

FROM File

Where not Exist(ExcludedMaterial, Material);

1 Reply
MVP
MVP

Re: Load only specific values

Try something like this:

Excluded:

LOAD Material as ExcludedMaterial

FROM ExcludedFile;

Table:

LOAD Material,

           AllOtherColumns

FROM File

Where not Exist(ExcludedMaterial, Material);