Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

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
petter
Partner - Champion III
Partner - Champion III

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;

View solution in original post

7 Replies
petter
Partner - Champion III
Partner - Champion III

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
Creator
Creator
Author

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?

petter
Partner - Champion III
Partner - Champion III

add this statement after the last statement:

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

bazzaonline
Creator
Creator
Author

THANK YOU!

petter
Partner - Champion III
Partner - Champion III

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

bazzaonline
Creator
Creator
Author

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

petter
Partner - Champion III
Partner - Champion III

Here is the tip to learn how to do it:

Qlik Community Tip: Marking Replies as Correct or Helpful