You will have this problem again and again in the future so you need to know how to handle it.
Please see the script in attached the sample file for details.
Hope it can help.
Get rid of null.qvf 192.0 K
Thanks a lot for taking the time to put together the sample qvf. Now, I understand where to write the scripts and how to create sample qvfs.
Now, I can see a category/classification called "Undefined" with count 0, and I still see a category with '-' and count 5. Below is the script that I wrote.
industrycodekey_ as SectorID
industrycodekey_ as SectorID,
industrycodekey_ as SectorIDInSectorTable // Notice here we create a new field.
//dimentity and dimindustry are the names of my tables with industrycodekey_ as the foreign key.
'Unassigned' as Classification,
'Unassigned' as Sector,
'Unassigned' as PeerID
where not Exists(SectorIDInSectorTable, SectorID);
drop field SectorIDInSectorTable;
I looked at the data in the dimentity table and the issue is not that the dimentity has a value not present in dimindustry, it because dimentity has NULL value for the industrycodekey_. How should I change the script now?