I am trying to put some validation checks in my Qlik Sense Load Script. The idea is to be able to compare distinct value counts between a dimension from a monthly file and a mapping table (which is maintained manually). For example:
In the above example, the mapping file is missing an entry for "White" sector, and hence would show a blank / Null in "Zone"
I want to compare the distinct counts in both these file during the loading process, and throw an error is there is a count mismatch.
whereby you will need to load the mapping-data twice - one time normal to be able to access the table/fields and then a second time as mapping-table which is in general unaccessable unless by using mapping functions/statements.