Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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);
THANK YOU!
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: