I have an app to calculate the usage of our warehouse - similar to one I already built for another one.
In the underlying Excel "database" where all the BINs and storage_spaces that can be used in the company_database are listed, there is one sheet >>Ausfiltern<< which means that all the BINs in the live_database which are not to be considered (because they do not represent a physical storage_space) are listed on that sheet.
=> Those are then loaded into a table
=> Using a WHERE NOT(EXISTS()) clause in the primary LOAD from the live_database, I filter out all the BINs listed on that sheet.
So far, that always works
<=> There is one BIN just called >>1<< which I cannot filter out and I don't understand why.
According to an ISNUM() query, it is numeric.
I have it listed on that sheet, of course, and it is properly loaded into the table in QlikView that I use for all those.
<=> Somehow it "survives" that clause and it is still in the table from the live_database.
=> Then I just added another specific clause >> AND [fieldname] <> 1 << or >> AND [fieldname] <> '1' << (I tried both)
<=> Somehow, that one BIN survives even those and it is still in the table.
I can do so, but for now the BIN is gone all of a sudden - so either my script has suddenly changed behaviour and it is now filtered out or it is just not being used anymore ..
Ah - now I know it - or, I know what is the matter, I don't know why yet ...
Seemingly, that BIN >>1<< is not in the LOAD from the live_database - then comes a series of APPLYMAP() commands where I map several BINs to one a number of times wherever there are several BINs which correspond to just one physical area because these of course have just one capacity.
=> and after that series of APPLYMAP() commands, that BIN >>1<< is there.
I don't know which part of my script exactly you need now? I guess the part where i create all those mapping_tables (incl. the underlying Excel file) and the part with all the APPLYMAP() commands.
