Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
You can first load the Excel sheet like this:
ExcelItemNumber AS ItemNumber // If necessary rename the Excel field to the same as in the other table
// At the end of the load statment you can have this:
DROP TABLE ExclusionItems;
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?
add this statement after the last statement:
STORE Data INTO LIB://QVD-Folder/Data.QVD (QVD);
You're welcome. Please mark the question as answered.
I can't actually work out how to even do that!
Here is the tip to learn how to do it:
Qlik Community Tip: Marking Replies as Correct or Helpful