Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bazzaonline
New Contributor III

Qliksense exclude from load based on list

Hello,

I'm loading data into qliksense and it contains two key fields IDNumber and ItemNumber plus others


The data contains some duplicate IDNumber's but different ItemNumbers, I want to exclude certain ItemNumbers in the load script which I have on a separate list in excel.

How can I exclude records in the load script where the ItemNumber is on the second list in excel?

Thank you in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Qliksense exclude from load based on list

You can first load the Excel sheet like this:

ExclusionItems:

LOAD DISTINCT

   ExcelItemNumber AS ItemNumber   // If necessary rename the Excel field to the same as in the other table

FROM

ExcelList.xlsx (ooxml,......);

Data:

LOAD

   ....

  .....

// At the end of the load statment you can have this:

WHERE

  Not(Exists(ItemNumber))

;

DROP TABLE ExclusionItems;

7 Replies
MVP
MVP

Re: Qliksense exclude from load based on list

You can first load the Excel sheet like this:

ExclusionItems:

LOAD DISTINCT

   ExcelItemNumber AS ItemNumber   // If necessary rename the Excel field to the same as in the other table

FROM

ExcelList.xlsx (ooxml,......);

Data:

LOAD

   ....

  .....

// At the end of the load statment you can have this:

WHERE

  Not(Exists(ItemNumber))

;

DROP TABLE ExclusionItems;

bazzaonline
New Contributor III

Re: Qliksense exclude from load based on list

Thank you Peter thanks excellent, any idea how I can save what is created as a QVD file as part of the load script.  I just want to save everything?

MVP
MVP

Re: Qliksense exclude from load based on list

add this statement after the last statement:

STORE Data INTO LIB://QVD-Folder/Data.QVD (QVD);

bazzaonline
New Contributor III

Re: Qliksense exclude from load based on list

THANK YOU!

MVP
MVP

Re: Qliksense exclude from load based on list

You're welcome. Please mark the question as answered.

Highlighted
bazzaonline
New Contributor III

Re: Qliksense exclude from load based on list

I can't actually work out how to even do that!

MVP
MVP

Re: Qliksense exclude from load based on list

Here is the tip to learn how to do it:

Qlik Community Tip: Marking Replies as Correct or Helpful

Community Browser